In Access, Where do I find SQL Query Builder for forms; unbound co

G

Guest

Hi, please let me know how to get to the combo box drop-down list and how to
modify this list. Also I'd like to know SQL statement Query Builder. Thanks.
 
J

John W. Vinson

Hi, please let me know how to get to the combo box drop-down list and how to
modify this list.
Click to expand...

Open the Form in design view; select the combo box; view its Properties (right
mouseclick); and find the RowSource property.
Also I'd like to know SQL statement Query Builder. Thanks.
Click to expand...

Open the query in design view and either select View... SQL from the menu, or
use the leftmost tool on the query design toolbar as a dropdown and select the
SQL icon.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iif then statement needed for Access 2007 please 5
Like clause used in query builder 1
Query builder enclosing fieldnames in quotes 3
parameter query 4
refer to a particular column in a listbox in a query 4
Calling Parameterized Query Using SQL Syntax 3
Lookup table troubles in query 2
Access 2007 - append query only appending 0 rows??? 0

Top