VBA?(about form)

[John]

I have a VBA as follows:



DoCmd.OpenForm "DLRQ", acNormal, acEdit



then this form list 300 records one by one,there is "Textbox 1" where I can
write information in ,above the form

If I want to open this form and only show me the record where the [Dealer
Name] in the form is equal to the "Textbox 1"

How should I write this VBA?



Thanks!

 

[John W. Vinson]

I have a VBA as follows:



DoCmd.OpenForm "DLRQ", acNormal, acEdit



then this form list 300 records one by one,there is "Textbox 1" where I can
write information in ,above the form

If I want to open this form and only show me the record where the [Dealer
Name] in the form is equal to the "Textbox 1"

How should I write this VBA?

DoCmd.OpenForm "DLRQ", acNormal, acEdit, _
WhereCondition := "[Dealer Name]=""" & Me![Textbox 1] & """"

 

[John]

Thank you very much!

John