There is a sample db attached. I have a table with the following columns;
Sale#
Type
Model
Price
Date
I have a form with 3 combo boxes;
Date
Type
Model
1 Text Box
Price
Command button
Enter Price
The combo boxes should not have duplicates in them and should narrow selection base on box aboves selection. Once you have all 3 combo boxes selected you can enter a price and it will only go to the price column but only in the rows that matche the information from the combo boxes.
Sale#
Type
Model
Price
Date
I have a form with 3 combo boxes;
Date
Type
Model
1 Text Box
Price
Command button
Enter Price
The combo boxes should not have duplicates in them and should narrow selection base on box aboves selection. Once you have all 3 combo boxes selected you can enter a price and it will only go to the price column but only in the rows that matche the information from the combo boxes.