Forms, multiple record entry

M

Matt

hi, Access 97

I'm using a Form for data entry and naturly I have a Record Number that
counts up every time I open a new record so I can keep tract of of the data
in the Table. The Record Number is my "key". What I'm trying to do is have
multiple Record Numbers (with sequencing values) on the same data entry Form.
For example if I have two part numbers running at the same time I want to
record both numbers with their other fields in the same data entry Form and
have them go to the same Table.

any help please!
 
K

Klatuu

You are creating a real problem for yourself.
That number you see in the lower left of the form is not a record number.
It is the relative position of the record in the table. That number is not
tied to any specific record. If you filter or sort or add or delete records,
that number will change. You cannot expect it to point to your data. That
is what autonumber fields are for.
 
M

Matt

I'm sorry when I was refering to "Record Number" I'm refiring to a control
box in my Form not the record index at the lower left. still same problem
 
Top