data entry

[drewcp]

I have two subforms on a form, on the first there is a table and on the second there are data entry fields

i would like to be able to click on one of the records on that table in the first sub-form and have it select that record set for data entry on the second sub-form.

does anyone have any suggestion for me on how i could do this?

 

[drewcp]

here is a visual example of what i was talking about because i don't think that made any sense.

http://qvepgq.bay.livefilestore.com...qgLxRizYz_VSQ0kQXvItsJ5l_udxE/batch query.bmp

So the way that the form is set up is that there are thee sub-forms on it, there is no main form. You can see what the three sub-forms are because of the different color of the labels.

On the first sub-form (Batch Query - located on the left side of the picture) I want to be able to put in a batch number and it will populate all the serial numbers that are assigned to that batch (which i already have it doing).

Then i want to be able to click on one of the serial number from the list and have it apply a filter to the other two sub-forms.

all the tables have serial numbers and what i am trying to accomplish is a data entry form so i need to have the two sub-forms on the same record.

If anyone can help me with this I would greatly appreciate it.

 

[karmawheel]

The form you have embedded your subforms on is actually the main form for this collection of subforms, even though you're not using the form as such.

You could easily bind this "main" form to your table that contains the serial number data, and then bind the subform(s) to the main form by using the Link Master and Link Child properties of the main form. Then whatever record (serial number) you select on your main form, you will automatically move your subform(s) to the same record, keeping everything in synch.