Displaying records from a search

[Dreamcatcher]

Hi,

I 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

 

[Fifty2One]

I can not see your attached zip because I am on horribly slow dialup. As a suggestion, I usually put combo boxes on a Search form for each type of search the end user would want to do. Then on the On Double Click event place the event to open the results form like this sample to open the ICITEM Query form from someone selecting from the Item list on combobox Combo0

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "ICITEM Query"
    
    stLinkCriteria = "[ItemNoTrim]=" & "'" & Me![Combo0] & "'"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

You will need to have a query with the needed fields to generate the separate form so you can pull together all your linked fields.

Hope that helps maybe...

Hi,

I 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