I created a form (frmCrewing) using a table (tblCrewing) as the control source. Also in the from there are combo-boxes with the the table as the control source and code in the row source to pull information from a table (tblRawData).
The first thing I need, is to be able to pull the 'Speed' from tblRawData based on the the 'WC' and 'Die' that is selected in the form and I would like the 'Speed' information to shown in real-time based on the trial.mdbselections made. I have an idea on how this can be done but I need an efficient method as there will be thousands of records in the from and it needs to be fast.
Second, when info is entered in the form, I need it to be automatically transferred to the table. For example if I change 'Die1' and move over to change 'Die2', 'Die1' does not get transferred to the table, it only happens if I click the combo-box below 'Die1'.
I have also posted a small example of the form and tables.
If someone can give me some methods on how this can be done, I would greatly appreciate it and I tried to explain what I want as best I could but if something is unclear please just ask and I will try to clarify.