Open Form question

[jbphoenix]

My main form has a Customer_ID, Order_Status, Type, and Create_Date and a bunch of other fields that get pulled in based on the customer_ID from a Customer table in a linked database.

I have another form that has all the order details - address, shipping info, notes, etc.

A 3rd form in datasheet view that has line item info like part_ID, line_no, unit_price, etc.

And finally a 4th form that has RMA data like, part_ID, description, RMA_Defect and customer_ID.

I would like to have my main form with a btn on it that will open a second form with all the other forms on it. Is it possible to have some of the data from the main form appear on the other forms? I know how to do it if they are all subforms. I can give a better explanation about my situation if you need.

Thanks

 

[KeithG]

You can use the Filter property of the form.

 

[jbphoenix]

Do you mean when I right click in the upper left corner and choose properties and then on the data tab choose filter?

 

[rainman89]

in the onclick of the button you can put something like

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "Mainformname" <-this is the one that has all the others as subforms
    
    stLinkCriteria = "[Customer_ID]=" & "'" & Me![Customer_ID] & "'"
    DoCmd.OpenForm stDocName, , , stLinkCriteria