go to record of a form from a subform

D

dar.nashr

hi
i have a form in data entry mode and a subform showing the related
records to the form. i want to double click on the a specfic record in
the subform the shows me the details in the main form. what is the
best way in doing it.
thanks
 
A

Allen Browne

I don't understand this question.

The normal way you set up a form with a subform is to match a one-to-many
relationship. The table on the ONE side of the relationship is the source
for the main form. The table on the MANY side is the source for the subform.

If you set up your form like that, you only see the related records in the
subform if you already have the correct record in the main form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locate record in a subform 1
go to specific record based on choice in subform 2
Access Main form/Subform Navigation 0
Append Records from a subform to a new record 1
showing a subform based on the main form 5
Duplicate record in Form and Subform 0
Open form to proper record 6
Deleting records from a subform 2

Top