Full Version: Displaying records from a search
UtterAccess Forums > Microsoft® Access > Access Forms
want to display records in a Form, relevant to the search critiriea entered by the operator.
I.e. In the attached database, i want a button on the switchboard 'Search by Client Ref Number', this will bring up a box allowing operator to enter the Client Ref number. I then want to open the frmRecords showing only those records for that Client Ref number.
Problem i have is that the ClientRef is NOT in frmRecords. frmRecords contains CustomerID control which is a FK linking to the tblCustomers. The tblCustomers is where the ClientRef field is.
Can someone assist me please on achieving the above.
Many Regards
here's several ways of doing it. The attachment is your db modified for you to show one way.........
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.