Saturday, 31 August 2013

MS Access 2007 - Need to link command button to selected value in list box to open customer form from search results

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