data access pages and combo boxes

E

elsa

I work on MS Access 2002 and need to capture information
on a data access page.

Everything is working fine, except that one of my combo
boxes has a list of units associated with a jobnumber.
When I click this drop down, it shows me all the units for
all jobnumbers. How can I change this combo box to only
show the units relevant to the specific job?

It is easy to do this on a form, because you change the
SQL statement, but how do you do this on a data access
page?

Help will be much appreciated
Elsa :)-)
 

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

Access data pages and combo boxes 0
Combo box 0
Please help.. if you can!! 0
Combo Box Help 7
combo box locked 4
Combo Box Default Value 0
Blank combo or list box 1
data access pages and combo boxes 0

Top