Full Version: Displaying records from a search
UtterAccess Forums > Microsoft® Access > Access Forms
Dreamcatcher
Hi,
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
Alan_G
Hi
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.