Tabular Form with a control source table

[mk1]

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.

[June7]

Sounds like you want a dependent (cascading) combo/list box, review: http://datapigtechnologies.com/flash...combobox2.html

If you want to filter form RecordSource, parameterized query is one method, review: http://datapigtechnologies.com/flash...tomfilter.html

Data is committed to table when form closes, move to another record, or run save record command.

[mk1]

Thanks for the response, and sorry for the delay.

I managed to look through the videos, and the parameterized query method was the closest method to what I need. But in my example the record source of the table is tblCrewing and the information going into 'Speed1' is coming from tblRawData. I essentially need two record sources for the form. The control-source of 'Speed1' would still be tblCrewing, so the speed information would have to taken from tblRawData and inputed into tblCrewing based on the selections made in the form.

[June7]

I don't understand. Did you mean 'record source of the form is tblCrewing'?

A form can have only one RecordSource. The RowSource of combobox would be dependent on values selected in other controls.

If you want to provide db for analysis, follow instructions at bottom of my post.

[mk1]

I'm sorry, I did mean 'record source of the form is tblCrewing'.

I have posted a db for analysis.

[June7]

I don't understand your data. Maybe 2 records in tblRawData aren't enough to evaluate issue. If each WC value has only one each DIE and SPEED, why do you have 2 fields each for DIE and SPEED in tblCrewing? And if WC is unique in tblRawData, DIE is irrelevant to the selection of SPEED, just select WC.

[mk1]

I added more data to the tables to help you understand, and attached another db.

Each WC for each day is generated into the table, and the die selected can correspond to any of the WC.

Hope this helps

[June7]

Speed is dependent on both WC and Die. Appears Die is unique for each WC

Could have a unique ID (autonumber) field as primary key in tblRawData and just save that value as foreign key into tblCrewing.

Why isn't WC also a combobox?

Value selected in WC combobox would restrict choices in Die combobox. Select Die and save the PK in tblCrewing.