Sup ppl
I have a form where there is 2 combo boxes and 1 list box. What I want to do is when a user selects 1 date in combo box and 1 date in the other combo box(the first combo box always has to have the oldest date), all the pieces that are from the first date, selected in the first combo box, to the other date, selected in the other combo box, are displayed in a list box right underneath these combo boxes.(the list box should contain 2 columns, to display the CustomerID + PartNumber). However, in the table containing these dates, there's a field called "OUT", to see if the piece is out of the factory. This field is a yes/no type format. I don't want the pieces with a check mark to be displayed in that list box, but rather in a subform will is on the right. How could I do it.
2]
Now lets say the user selects some pieces from the list box, How could I do it so that the selected pieces go on a report with extra information from TblClients?
Pm me if you want a sample of the database
Thanks a lot!
I have a form where there is 2 combo boxes and 1 list box. What I want to do is when a user selects 1 date in combo box and 1 date in the other combo box(the first combo box always has to have the oldest date), all the pieces that are from the first date, selected in the first combo box, to the other date, selected in the other combo box, are displayed in a list box right underneath these combo boxes.(the list box should contain 2 columns, to display the CustomerID + PartNumber). However, in the table containing these dates, there's a field called "OUT", to see if the piece is out of the factory. This field is a yes/no type format. I don't want the pieces with a check mark to be displayed in that list box, but rather in a subform will is on the right. How could I do it.
2]
Now lets say the user selects some pieces from the list box, How could I do it so that the selected pieces go on a report with extra information from TblClients?
Pm me if you want a sample of the database
Thanks a lot!
Last edited:
