I am trying to create a table (or form) where I pull data from a seperate table and if I fill in the 2nd field, the 1st field fills in automatically, or if I fill in the 1st field, the 2nd fills in. The 2 fields are a number and its name; where each are unique. I am sure I have done this before with either a table or form but can not get it to work now. Thank you in advance.
-
-
If you are talking about textboxes then you can use the textboxes after_update event in vba to to fill in another textbox once the current one has been completed.
If you mean the same thing with comboboxes, then you can look up cascading comboboxes which basically uses the same method as above but changes the second comboboxes recordsource to a sql string based on the selection made in the current combobox.
Comment