January 16, 2012 at 6:31 pm
Glad I could help.
What I forgot to add in my initial post was a broad explanation of what is happening, in case anyone else ends up reading this thread. I find it easier to remember the "how" if I know the "why".
As I mentioned in my earlier post, successful databases rely on consistency; without that we might as well go to the beach. Combo controls combined with lookup tables or defined lists, help us maintain consistency by providing a mechanism for putting in front of the user, a constant set of values from which to choose. The other option is to allow them to type in whatever they want - goodbye consistency, hullo beach 😎 (me at the beach)
The combo control itself simply provides a list which incorporates the foreign key values. When an item is selected from the combo list, it stores the Bound Column value (being the foreign key value of the item selected) on the control, effectively adding this value to the record being maintained by the form at that time. Note that you can also access the values in the other columns for the item selected via VBA, using the column number (refer to the MS Access help on the specifics of how to do this).
All the best.
Rowan
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply