Showing data from main form in linked forms

[llasher]

I have a main form, and I was hoping that the data I enter into a particular field ("UR" which is the primary key of the main form) appears in other forms linked by a command button. There is a relationship created btwn these two forms, linking the field, and it works OK with subforms ie. when the same form is made a subform, the UR field entry appears in the subforms.

Is there a way of making this entry appear in forms opened by the command button?

llasher (newbie)

 

[BLeslie88]

sure...

pass the parameter...

look up functions in the help file.

assign the value from your txtbox to the string/long to be passed and pass it through, functions can pass a parameter to an opening form....

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmOrders"
DoCmd.OpenForm stDocName, , , stLinkCriteria

actually... stLinkCriteria is that parameter... this can be used to filter a query or table on the opening form.

or you can code it... as you wish...

 

[llasher]

Thanks for your help...I don't suppose there's a way to do it without learning VB? (Go and buy Filemaker Pro? ) No box I can simply tick in a wizard or something?

Thanks, I am ascending the hill of Access slowly