multiple drop down menus

M

Mandy J.S.

I have a database that I just created. This table that I am working in is
InvoiceTable. My first field is Job #. This is a drop down menu from a
query off of the POTable that has found the duplicate Job #'s and
consolidated them. My second field is where I am stuck. The second field is
P.O. #. I want to have the query take the Job # that was selected in the Job
# field and give me what the PO #'s are available from the POTable. Here's
what I have so far for the SQL:

SELECT First(POTable.[Job Order #]) AS [Job Order # Field],
First(POTable.[PO #]) AS [PO # Field], Count(POTable.[Job Order #]) AS
NumberOfDups
FROM POTable
GROUP BY POTable.[Job Order #], POTable.[PO #]
HAVING (((Count(POTable.[Job Order #]))>1) AND ((Count(POTable.[PO #]))>1));

The next field after this one is Sub Job #. I want to then select from just
the sub job #'s for that PO #.

I am using Access 2007 in Windows XP Professional environment.

Thanks for all of your assistance.

Mandy Jo
 
S

S.Clark

The first() function is misleading, as it can return any record, based on the
sort order of the table. ( Same with Last() ). I try to avoid using these
at all.

Typically in a two combobox setup, I use the afterupdate of the first to
update the rowsource of the 2nd.

cboSecond.Rowsource = "Select * from ... where field = " & cboFirst.value
 
Top