Go Back   Access World Forums > Search Forums

 
Showing results 1 to 3 of 3
Search took 0.00 seconds.
Search: Posts Made By: tonylomax
Forum: Queries 11-21-2018, 03:32 AM
Replies: 8
Views: 970
Posted By tonylomax
Re: Access 2016 Using combobox in SQL query

@Minty The form does close however I've figured out what I needed to do. I didn't realise you needed to specify which column was bound even if you only have one column visible on the combo box. I...
Forum: Queries 11-20-2018, 08:18 AM
Replies: 8
Views: 970
Posted By tonylomax
Re: Access 2016 Using combobox in SQL query

Thanks for the replies. @MajP I've adjusted the query as suggested and no luck, I get an Undefined Function error.

@Ranman256 I will look into your suggestion though that would make the interface...
Forum: Queries 11-20-2018, 04:44 AM
Replies: 8
Views: 970
Posted By tonylomax
Access 2016 Using combobox in SQL query

I'm trying to create a query that uses the selection of a single combobox as part of the WHERE clause.

The query:

SELECT Database.Contact_ID, Database.[Full Name], Database.[Job Title],
...
Showing results 1 to 3 of 3

 
Forum Jump



All times are GMT -8. The time now is 02:38 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World