Multiple Filters on form?

[honey2wood]

Hi to all.

This problem has possibly a very simple solution but I just cant get my head round it. I have looked through this forum but cant find anything to help.

I have a linked table of data. This is then made into a query.
It has a date column, which gives me the day of the orders.
It has a Purchase order column, _up to 50 a day)
It has a Lot Number column, (around 20 per PO)
Each day a number of POs arrive, each with a number of Lot numbers.
What I am trying to do on a form is select a date Then select a PO to identify the lot no. then select a lot no.
The date is not a problem as I can use the query criteria to open the form but when I try to use a combo box to get the PO it gives me a list of each PO a number of times.
I have made the combo box using the Lot number but I do need to get the PO first.
As I said before I cant think how to do it.
Thank you in advance for taking the time to read this. Any suggestions would be gratefully received

Graham

 

[Brianwarnock]

Are we talking cascading combos here, if so this might help

http://www.baldyweb.com/CascadingCombo.htm

Brian

 

[honey2wood]

Hi Brian
Thanks for getting back. This link did not seem to work though.
I think it might be cascade the combobox but I need to get single POs. I can do this manually in the query by using the column filters but I need to do the same in the Form. Or am I asking too much.

Graham

 

[Brianwarnock]

Ok don't know what went wrong before try again.
http://www.baldyweb.com/CascadingCombo.htm

 

[Brianwarnock]

I don't really follow this, I thought you wanted to list all POs on a given date , then you would select 1 to identify the lot number.

I need to get single POs. I can do this manually in the query by using the column filters but I need to do the same in the Form.

Brian

 

[honey2wood]

Hi again Brian

Sorry to cause confusion I did not complete the requirements.
Yes you are correct I do want a list of single POs so that I get a single list of Lot Numbers against each PO. I will have a look at the site you gave me and get back Thanks once again.

Graham

 

[honey2wood]

Thanks once again Brian. I have been able to do what I wanted to do with your guidance.

Graham

 

[Brianwarnock]

Glad I was able to help, but I think Paul (aka Pbaldy) is the real one for us to thank with his examples.

Brian