Data Entry Form for specific assets

[Davepacey]

Data Entry Form for Multiple Records

Hi,

Long time since posting on here

My Problem:

I have a bank of 8 machines, I need the user to enter one record for each machine in order. I currently have these machines in a combo box, but any other method would be fine.

When the user opens the data entry screen, I need it to open a data entry with that machine selected and the machine number pasted to the [Machine_No] field, when the user has finished entering the data (mainly yes/no tick boxes) I need them to click a "Next" button and have the data entry form to move on to the next record, the next machine on the list. This needs to be done in machine order as listed. I would then like the "Next" button to be hidden or disabled or changed to "Finished" (Close Form button)when at the last machine in the list.

Is this possible please ?

EDIT: Sorry, I am using Access 2010

Any help appreciated

Davepacey

 

[MarkK]

How much data do you need to enter for each machine? If not too much, I might just make a non-normalized form with 8 rows of textboxes.

But is it possible? Yes. You can pre-add the records you need and display them in a datasheet or a continuous form, or display them one at a time. Or save the list of computer names/IDs in a table, and incrementally update the default value of a control for each new record. There are tons of ways.

 

[Davepacey]

Hi,

Thanks for the reply, I have actually done it another way now, I gave up on this method. It did not look clean or easy.

I opted for a menu with buttons for each machine, that works very well

Thanks again.