Querry Help Needed

[tmartin]

The criteria I have for a standalone query is
Like "*" & [Forms]![SearchForm]![txtCustomerName] & "*"
and this works fine for the Client field.

How do

This will work however I need to add the Like to allow for a better search. Any idea how to embed the Like with the DoCmd.OpenForm commmand in VBA

DoCmd.OpenForm "TransactionsForm", acNormal, "", "[Client]=[Forms]![SearchForm]![txtCustomerName]", acReadOnly, acNormal

[orange]

Are you trying to build a search form? or trying to open a second form and show the info for the record you selected in the first form?