Use Checkbox to select record, Send data to Tbl

[zmbd]

Because your third party site is blocked I'm having a hard time visualizing your project.

Are you after something like this? Split Forms Acc2010

[NeoPa]

it appears to me (note that sad context) that I need to keep the second combox unbound. Otherwise, It gives me a duplication error as I have that field set to no duplicates.

That is a problem for another day (I suspect). Let's leave that aside unless and until we need to deal with it. Why you have it set that way seems the confusing question, but not to be dealt with here and now. One issue per thread is the rule here.

[NeoPa]

Because your third party site is blocked I'm having a hard time visualizing your project.

Try again now Z. I've added another (albeit smaller) version to the post hosted on Bytes.

[SisterSue]

Ok, here we go!

Main Form based on Table: Project_Desc

Combo1 Name: CustList
Unbound, Tbl to "Customers"
Field in table: Customer_Name

Comb2 Name: ProjList
Unbound, Tbl to "Project_De sc
Field in table: Project_Name

NewCombo3 Name: KDList
Unbound, Tbl to Knowledge_Divis ions
Fields Knowledge_Divis ion, KD_ID

SubForm: All fields from tbl: Knowledge_Divis ions

Are you also not able to see my pictures (I'll include links as well).

Here are two:

1) Relationships

http://www.techlaborate.com/wp-content/uploads/2014/02/Rltnscrn1.png

2)Form

http://www.techlaborate.com/wp-content/uploads/2014/02/Scrnshot1.png

Thanks!!!!!!

[SisterSue]

Thanks ZMBD,

I know a split form would be a lot easier. Sadly, I do not want the Datasheet view. Am I able to change the formatting in top and bottom?

Appreciate it.

[NeoPa]

Yes, the drop down boxes are linked to customer and project tables with multiple choice combinations.

I understood this to imply that the controls on the Detail section of the form were bound. If they are not, which now seems to be the case, most things change.

[SisterSue]

My apologies. They were bound, and I forgot that I changed that. I can easily rebind them. I will work on solving my issue of binding with duplicates after. Sorry for the confusion.

As a result, they will both be bound to the tbl Project_Desc, same field names.

[NeoPa]

OK Good. I'm sure we can proceed from here.

Unfortunately I'm in London and really flagging at this time of the evening. I'll try to remember to look at this again tomorrow. Time will be tight then too, unfortunately. Let's see what we can come up with. if not tomorrow then Thursday should be relatively free.

[SisterSue]

You're my hero! Thanks NeoPa!

[SisterSue]

NeoPa, Please don't be (too) frustrated with me. I just found the solution to my duplicates problem here: http://answers.microsoft.com/en-us/o...c-486d47433ad9

It's the three tables with the relationships. I will spend tomorrow reconstructing my tables. Then I will repost with the new Bound Columns, table data like I did before.

BTW, could you see the pictures this time?

PS. Am I allowed to pay you?

[NeoPa]

Let me say it's a very good idea, when asking questions about one issue, to keep all other issues unchanging for the duration of the first issue. It doesn't mean you have to make no other progress, just simply that any other progress is kept away from interfering with the progress of the issue being concentrated on. If you think about it I'm sure you'll see why this makes sense. It's hard enough to work from a very unclear picture as expressed by someone you don't know via the limited interface of a web page. If you add changing parameters, as well as fundamentally unclear ones, you reduce your chances of getting a satisfactory answer by many times. It just makes sense to keep any unnecessary changes out of the way until after you learn what there is to learn from the first question. My guess is that you're bright enough to see the sense of this now it's been pointed out.

Don't get me wrong. I'm pleased you're picking other things up too and learning on more than just one front. It's just that it's a good idea to keep them totally separate for the benefit of progressing this particular question. That said - go for it. I can handle a bit of parameter changing on me without panicing too much. A point well worth remembering for any future questions though.

I see all the pics fine BTW. It's Zmbd who has difficulties as he, like very many others, has to access from a secure network where many sites are blocked. Some third party sites, such as where your pictures are stored, are unavailable to them.

Payment is an option. It's not requested - certainly at this time. However, if you're looking for professional help and have someone in mind then feel free to contact them by PM to ask for their terms and how they're placed. Most post in their spare time but many are professionals who can be contracted.

[SisterSue]

As mentioned, thank you for the feedback and understand the point of your response. Here are the changes:

Main Form based on Table: Project_Desc

Combo1 Name: CustList
Unbound, Query Look up to "Customers" and "Projects"
Shown Field in table: Customer_Name

Comb2 Name: ProjList
Bound, Tbl to "Project_De sc
Query Look up to "Projects",
Field in Bound table: ProjID

New Combobox Added: KBID
Bound, to field KBID
Query Look up to "Project_De sc" and "Knowledge_Divi sions"
Fields in Bound table KBID

SubForm: All fields from tbl: Knowledge_Divis ions


ScrnShot of Form:

http://www.techlaborate.com/wp-content/uploads/2014/02/Scrnshot11.png

ScrnShot of Rltn Tables:

http://www.techlaborate.com/wp-content/uploads/2014/02/Rltnscrn2.png

Appreciate it!!!

[NeoPa]

New Combobox Added: KBID
Bound, to field KBID
Query Look up to "Project_De sc" and "Knowledge_Divi sions"
Fields in Bound table KBID

I'm not sure about this. The ComboBox just added should have a .ControlSource that links it to a single table or query. The control itself should be bound to one of the fields in the .ControlSource. I'm guessing the field is [KBID]. Not sure what .ControlSource is. From the picture it's not even a ComboBox.

Looking at the table diagram I guess .ControlSource should be Proj_Desk.KBID.

From the form picture we see the lower data (The subform most likely at this stage) is showing with two records checked. I would expect this shouldn't be possible. When a KBID is selected then all others should be reset.

Last point for now - You do appreciate the way this is requested to work will force the project to be single user. If you had two versions working at the same time they'd interfere with each other horribly.

[SisterSue]

Images as attachments

Well ZMBD,

It appears I continue to disappoint! The options under the advanced tab are the same I was using previously. I have added the images as attachments for another option.

Thanks so much
[IMGNOTHUMB]http://bytes.com/attachments/attachment/7512d1392860872/rltnscrn.jpg[/IMGNOTHUMB]
[IMGNOTHUMB]http://bytes.com/attachments/attachment/7513d1392860872/scrnshot1.jpg[/IMGNOTHUMB]

[SisterSue]

Hi NeoPa,

The box is a listbox (apologies). It's control is KBID from the table Project_Desc.

You are correct about the subform. I have it there to show what I was going for; however, it's not connected or updating on anything at this point.

To your final point, I understand. And the entire project is designed to only be used by one.

Thanks again!