Full Version: How To Link To Seperate Forms.
UtterAccess Forums > Microsoft® Access > Access Forms
Taslo
Is there a way to link two seperate forms?
don't want it inside the parent form. I have created a button to make the subform open, but it shows all records. I just want it to show the information related on the parent form.
theDBguy
Hi,
If you are using the OpenForm method and your main form has a Primary Key ID, then you can utilize the WhereCondition parameter, such as:
DoCmd.OpenForm "FormName", , , "[ForeignKeyID]=" & Me.PrimaryKeyID
Hope that helps...
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.