pinkpanther6666
New member
- Local time
- Today, 22:02
- Joined
- Jan 28, 2010
- Messages
- 9
Good Evening
I have a form called frmSupplies with 2 x ComboBoxes in it called Combo1 and Combo2
Combo1 shows data from a table called Supplier1
Combo1 shows data from a table called Product1
I have a subform called subData in the same form
This has various fields in it and 2 are called Supplier1 and Product1
If i want to select in the main from from Combo1 a supplier and in combo2 select a product how do i get the subform to filter this data out:banghead:
The subform contains about 1200 lines of data and is constantly been added to.
Many Thanks in advance
Cheers
Steve
I have a form called frmSupplies with 2 x ComboBoxes in it called Combo1 and Combo2
Combo1 shows data from a table called Supplier1
Combo1 shows data from a table called Product1
I have a subform called subData in the same form
This has various fields in it and 2 are called Supplier1 and Product1
If i want to select in the main from from Combo1 a supplier and in combo2 select a product how do i get the subform to filter this data out:banghead:
The subform contains about 1200 lines of data and is constantly been added to.
Many Thanks in advance
Cheers
Steve