chuckcoleman
Registered User.
- Local time
- Today, 06:58
- Joined
- Aug 20, 2010
- Messages
- 363
My brain is fried and I'm drawing a blank.
I have a single form that has a subform, which is continuous. I want a combo box, (on the continuous form), query's all of the values from a table/query. After the user selects the value, like maybe "Boots", I want the AutoNumber for "Boots" stored in the underlying table for the continuous form along with the Parent forms autonumber. When the user clicks on the combo box again, I DON'T want "Boots" to show up again, because it has already been used. When the user moves to another record on the parent form, the Link Master/Link Child keeps the continuous form in sync with the parent.
I've drawn a blank on making sure that "Boots" in my question doesn't show up again for that "Parent".
I have a single form that has a subform, which is continuous. I want a combo box, (on the continuous form), query's all of the values from a table/query. After the user selects the value, like maybe "Boots", I want the AutoNumber for "Boots" stored in the underlying table for the continuous form along with the Parent forms autonumber. When the user clicks on the combo box again, I DON'T want "Boots" to show up again, because it has already been used. When the user moves to another record on the parent form, the Link Master/Link Child keeps the continuous form in sync with the parent.
I've drawn a blank on making sure that "Boots" in my question doesn't show up again for that "Parent".