COMBO BOX PROBLEM-Any help ?

[dk]

Hello everybody !
I have form with listbox "Suppliers" and subform called "recieved invoices".
Recieved invoices subform source is query like "Select invoices where
Supplier ID=List Box" (simplified)
Now, Id like to put combobox to reduce displayed invoices to years.
I changed query behind subform into "Select invoices where
supplierID=Listbox & Year(Invoicedate)=Combobox"
The problem is when I need to see all invoices concerning particular
supplier.
How can I put into Combobox value All invoices

Thank You for Your suggestions

DK

 

[Arvin Meyer]

I'm sure you set the subform data to requery each time the list box or combo
box are updated. So the trick is to force an update. I'd add a command
button which cleared the selection and force the requery. (aircode)

Sub cmdComboClear()
Me.MyCombobox = ""
Me.RecordSource = "Select Invoices Where Supplier ID=List Box"
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

I "believe" this link will explain how to fix your problelm:

http://www.gr-fx.com/toolshed/01_access/comboqueries.htm

The idea is that you need to add All the your comboboxes and you need your
queries that refer to it to use the Like operator...

-Steve Huff
http://www.huffs.us

 

[dk]

Thank You Arvin and Steve.
Steve, Your solution is fine
Thank You soooo much
DK