Uh Oh

manovice

Registered User.
Local time
Today, 14:12
Joined
Nov 21, 2008
Messages
11
I just went back and looked at my query and something is terribly wrong.

When I open my form to enter new information... I use the combo box to choose a facility. Each facility has an ID but I choose the facility name since the ID would be too difficult to remember for over 200 facilities.

But now... when I choose the facility from the combo, the address fields automatically fill in via (Combo17.column(2), etc.). And then I manually enter the review information. But now, I go back to the query and it is creating a new ID for each review. So instead of repeating multiple facility IDs (because they have multiple reviews) it is adding a new ID and then storing the facility ID under the facility name and not pulling any of the address information.

You guys are probably all thinking I am completely incompetant in this, and I am sorry to admit that I am. But I learn quick and have gathered various resources and materials but am having no luck.

Any suggestions on this problem?
Thanks
Nicole
 
you want your combo box bound to the facility table, but only the name and ID, have ID in column 1 and the name in column 2. have the combo box bound to column 1, and then have the column widths as 0cm;2cm

That should give you a combo box that only displays the facility name, but returns the ID when you click on it
 

Users who are viewing this thread

Back
Top Bottom