Automation for daily task.......

[JCross]

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

 

[Romulus]

Hi Jennifer,

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

 

[JCross]

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