Good Morning everyone. I have a form with two combo boxes and 1 command button. I am trying to use the command button to search a table and populate a query. I will then have the query display the results in the form (as a subform I presume). I have all the fields I need in the query and I included a WHERE clause that states:
WHERE ((([Forms]![Records_Search]![cboByTitles])=[List of Work Update Query]![Title]))
I basically want to populate either (mot both) the By Title (cboByTitle) or the By Publisher (cboByPublisher ) combo boxes and query all the records in the database table that meet the criteria. There could be multiple entries for both in the table. The table name is List of Work Update Query. I know that needs changed but I want to make this work first and then I will modify it everywhere I need to.
When I run the query I am not getting any returns, even though I have verified there is a record in the database with the title name in the combo box.
Any help would be greatly appreciated.
Thanks,
Doug
WHERE ((([Forms]![Records_Search]![cboByTitles])=[List of Work Update Query]![Title]))
I basically want to populate either (mot both) the By Title (cboByTitle) or the By Publisher (cboByPublisher ) combo boxes and query all the records in the database table that meet the criteria. There could be multiple entries for both in the table. The table name is List of Work Update Query. I know that needs changed but I want to make this work first and then I will modify it everywhere I need to.
When I run the query I am not getting any returns, even though I have verified there is a record in the database with the title name in the combo box.
Any help would be greatly appreciated.
Thanks,
Doug
Comment