going from master form to detail form

R

rodchar

hey all,

i have a form that lists all the parent records for a file. i have another
form that shows a parent record with all its child records in a subform.

how do i connect the 2 forms, for example, double click a record in the
parent form and bring up the 2nd form?

thanks,
rodchar
 
J

jfc

I could only think of fine-tuning your second form so that
it provides some functions to allow the user to select the
desired parent record. After hitting a button, make the
system to 'scroll' to the desired parent record.

My 2 cents.

jfc
 
V

Van T. Dinh

Use the OpenForm Method and specify the "wherecondition" argument to open
the second Form with the required Record as the CurrentRecord of the second
Form.

Check Access (VB) Help on the OpenForm Method.
 
R

rodchar

thanks, this helps.

jfc said:
I could only think of fine-tuning your second form so that
it provides some functions to allow the user to select the
desired parent record. After hitting a button, make the
system to 'scroll' to the desired parent record.

My 2 cents.

jfc
Click to expand...
 
Top