K
klp via AccessMonster.com
Not sure if this is were I need to post my question or not.
I have an Sales Inquiry Screen that has a combo box on it to select the
customers contact. After all inquiries have been entered in they will print a
shippable report. If on the Inquiry screen the user does not select the
contact I want it to print all contacts. Currently in my query I have several
tables. The main table is tblSalesInquiry and I have tblSIProspContacts.
Depending on how I link the 2 tables, it will give me an outcome. So if I
link the 2 by their ContactID I get what is selected on the inquiry screen.
If I link them by their CustID I get all their contacts regardless of what
they select on the inquiry screen. Hopefully this makes sense and is not
confusing. So I guess, where do I need to depict my criteria? I have been
doing it in my query but I can't seem to get it. Any help is very much
appreiciated.
Kim P
I have an Sales Inquiry Screen that has a combo box on it to select the
customers contact. After all inquiries have been entered in they will print a
shippable report. If on the Inquiry screen the user does not select the
contact I want it to print all contacts. Currently in my query I have several
tables. The main table is tblSalesInquiry and I have tblSIProspContacts.
Depending on how I link the 2 tables, it will give me an outcome. So if I
link the 2 by their ContactID I get what is selected on the inquiry screen.
If I link them by their CustID I get all their contacts regardless of what
they select on the inquiry screen. Hopefully this makes sense and is not
confusing. So I guess, where do I need to depict my criteria? I have been
doing it in my query but I can't seem to get it. Any help is very much
appreiciated.
Kim P