OpenForm cmd

[Access_Newbie_2]

Hello....Ive got a ? to ask! Duh! LoL....Here goes...

I have a Property Management dB. Its got a Custom Search form with many criteria (setup QBF using Dynamic SQL statement) in which is filters out records in the table based on user input. Now...the results are displayed on a continuous form, which only list the property address for each result (to fit alot of results on the original page) and next to the address or (preview form) there is a cmd button "View" which I want to open a new form displaying the complete record. Now i was planning on just using a macro with the open form cmd BUT how do i specify that this new form is JUST that 1 record? i see you can do Openfrm then goto Next, Previous, Etc... I want the current record from the results form to be displayed on the "Full View" form.. How can I accomplish this?

frmResults looks like

[View] 905 Dabney
[View] 906 Dabney
[View] 907 Dabney
[View] 908 Dabney

frmFullView would show ("View" cmd next to this result)

905 Dabney $300 Rent $400 Deposit W/D Hkup
Contact: Doug 619-885-9856
etc

Thanks!

 

[Mile-O]

DoCmd.OpenForm "frmMyForm", , , "MyField = " & Me.txtMyTextbox

 

[Access_Newbie_2]

Hey thanks for the help.... When I use that code I get "Method or data member not found" error message... I have tried naming my objects "MyTextbox" but I am unable to get past that error. Do you know why this error is appearing?

 

[Rich]

You have to replace the example object names Mile posted with your own