Hi all -

I have a form 'frmSalesMix, and a subform 'sfrmSalesMix'. Each day my users will enter the date, and then the same 20 rows of information in the same sequence.

These rows are stored in tblSalesMix_Details. Each row has the SalesMixID (associated with the date in tblSalesMix), a PLU number 1-20, the number sold, and the sales amount.

Is there a way for the 20 PLU numbers to automatically fill in so that the user does not have to type them or choose them from a combo box?

Thank you!

Jennifer

Hi Jennifer,

Maybe you can set the default value of each box to their respective PLU numbers, if the field is numeric.

The thing is that the subform is set to 'continuous forms' - so each line in the table is it's own separate form....which means that I have one combo box (or text box) for the field that I want to maybe loop through the PLU's and put them in sequentially?
To look like this:

line 1 - PLU#1 - # sold - Sales $
line 2 - PLU#2 - # sold - Sales $
line 3 - PLU#3 - # sold - Sales $

It's really just a matter of convenience for the user, since the PLU's will be the same every day and in the same order - i thought if I could fill them in automatically it would be nice.

Jennifer