Use form to input data

[thecrowtv]

So I’m having to develop a form that we can use in case in our web based inventory systems crash. i’m not good with forms at all.

I’d like the data entered to go into a table i’ve created with 4 fields.

So Field1 and Field2 will stay constant until we hit a button that does a whole new person we are issuing equipment to.

Field 3 and 4 though will need to generate a new record each time we scan data into both those fields.

For example the data table would look like this

Field 1 Field 2 Field 3 Field 4

Person1 IDNumber SerialA SerialB
Person1 IDNumber SerialC SerialD
Person1 IDNumber SerialE SerialF
PERSON2 TheirID SerialG SerialH
Person2 TheirID SeriaiI SerialJ

If it makes a difference this form will be done in Access 2010. Once I get the data into the table, I can do whatever I need to do with it.

I’m just trying to simplify for this for the people who would be using this form besides myself.

 

[llkhoutx]

You obviously have 11 fields, not 4. I suggest you rethink what you're doing. What's th difference between IDNumber and TheirID?

4 columns just makes it too complex because the form would have to know what columns are for what user. Assume all columns are for all users, or alternatively hide or disable & skip unused columns based up the Person.