Trying to pull in fields related to combobox selection from another table....
Windows 7 64bit 
Access 2010 64bit
I have 2 tables - Lots and Runs. Each lot contains several runs and both have their own data (ie. Lot ID, Lot SKU, Lot description; Run ID, Run SKU, Run Description). What I'm trying to do is have a form where I create a Lot, then a form to create a run associated with the lot you select from a combo box that pulls in data from the lot table. I've got all that done...
Now what I'd like to happen is - once you select a Lot SKU number from the combo box (in the add run form), the form automatically fills out a few fields associated with the Lot you selected so you can see the data for the Lot you selected as you enter the run data in the run form.
How can I do this? Thanks!
Reply With Quote
