MS Access 2007 - Need to link command button to selected value in list box
to open customer form from search results
I'm trying to create a simple form that allows the user to search for a
customer record, then either double click on the selected record from the
search results, or click a command button to open the selected record in
the customer form. I created a query linked to the "search for customer"
form that searches either last name, first name, or ID and returns the
results in a list box. That's as far as I got. Any help is much
appreciated. This is the criteria in my query:
Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*"
No comments:
Post a Comment