Multiple records form

[frdnwr]

Hello there,


I'm trying to figure out the logic for creating a form, that will insert multiple records into the same table in the following way :
I have 25 rooms
I need a form to enter - daily- what is the stock in each room
so I designed a form that lists 25 rows, each row is for one of the rooms, then the user should complete data for each row.

I also want to add something, I want to display the stock in the room for the last day, and, make it the default value in the current feild, so if there is a change in stock, user can type in the new value, else, he will leave it and it'll record yesterday's value.

Hope i made it clear, I really need help on this, been thinking of many stupid ways , but I can't figure it out.

[amrut]

Run an append query to copy previous day's record with a changed date to the table before displaying on form.

[Dal Jeanis]

That kind of design depends on how much you trust the user.
For instance, if you trust the user to be accurate:
A) The user clicks a button to state he's ready with the inventory.
B) The form copies all the prior day's records and inserts them into the table, setting a flag on each record that states the record is "unverified".
C) The form displays all unverified records.
D) The user changes any fields that need to be changed.
E) After each field of the record is verified, the user clicks "Okay" to mark it as verified, the screen is requeried, and the record disappears from the screen.

Or, if you don't trust the user, you could make it a game.
For each of the inventory fields for a room, have four radio buttons. Three of them would be (in random order) the prior day's actual inventory, and two random numbers plus or minus a few from the prior day's inventory. The fourth, the bottom field, would be an open entry field (maybe a spinner) that they could enter any actual inventory number into, if the three that you presented were not correct. That way, the user stays awake, the inventories stay accurate, and a lazy user can't just click "Okay" and get away with not doing her job.