By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,578 Members | 826 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,578 IT Pros & Developers. It's quick & easy.

Search button returns no results

P: 48
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
Feb 14 '08 #1
Share this Question
Share on Google+
1 Reply


P: 48
Sorry I forgot to mention this is in Access 2003.

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
Feb 14 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.