Forms, multiple record entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Matt,

What your are callin record numbers is reall a Record Identifiers. Access
tables do not have record numbers.

Sounds like you need to do you own custom auto sequencing. Check out this
post's code sample:

http://www.utteraccess.com/forums/showflat.php?Board=95&Number=1188303
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!
Click to expand...

--
Boyd
Hi Tech Coach
http://www.hitechcoach.com

Message posted via AccessMonster.com
 
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
 
Back
Top