VBA?(about form)

  • Thread starter Thread starter John
  • Start date Start date
J

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!
 
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?
Click to expand...

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