Originally Posted by
Ajax
depends on what you are doing with the subform.
If it needs to be updateable so users can change and add new records, change the relevant controls to combo boxes with a rowsource the fetches for example clientID and client name
If not, modify your recordsource to include the relevant tables and bring for example the client name through rather than the ID
Hi Ajax, Thank you for the response.
As indicated by the title on the main form, this is just a search form that updates the results in the subform from the query once the user hits the button. There is no edits or anything the user can do to alter the data from this form. It is only for searching purposes. I just want the text values to display in the subform as they appear in the main form.
Hope that helps clarify it a bit.
As for modifying the record source, I'm not certain what you mean here. When I created it, I used the following criteria:
Code:
Row Source: SELECT [tblClientsC].[ClientID], [tblClientsC].[Company] FROM tblClientsC ORDER BY [Company];
This is how the data source is defined in the main form for the drop down list for Client Name.
In the query, I used the criteria to pull from the main form's value in the corresponding field (a.k.a. the name of the textbox ClientNameSearch)
Code:
Like "*" & [Forms]![frmSearchClientInventory]![ClientNameSearch] & "*"