Loading searched data in a form

[noks]

Hi guys, am new in developing with Ms Access

I use Access 2003. I've got a search screen which is working perfectly fine. now i wanna load the data that's = to the search criteria but i want it in another (seperate) screen

Can u please kindly help as to how can i do that

1st screen (Search screen) contains 3 textboxes (customername, customersnumber and repname) which i search by

2screen (where i wanna load the data) i want it to contain everything it get regarding that search criteria. Please let me know if there r any Qs

Thanks
Noks

 

[MarkK]

Do you have a form designed for working with customer information? Use that form. Get your search to return the ID of the customer, then open that form to the ID from the search. You can specify filter conditions in the DoCmd.OpenForm action.
Cheers,

 

[noks]

lagbolt thanks 4 responding. i used this code

On Error GoTo Err_cmdGo_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form namr"
stLinkCriteria = "field name =" & Me![text name]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdGo_Click:
Exit Sub

Err_cmdGo_Click:
MsgBox Err.Description
Resume Exit_cmdGo_Click

and it's workin perfectly fine

cheers