RECORD SELECTORS

J

JOE POLLOCK

I AM ATTEMPTING TO CORRESPOND THE RECORD SELECTOR WITH THE ID FIELD IN A FORM
AND AM NOT QUIT SURE HOW TO SET THAT UP. PLEASE ANY HELP WOULD BE GREAT.
 
M

Mr. B

Joe Pollock,

I am not sure that I totally understand your question but, from your
comments, it would appear that you have an AutoNumber type field as a record
identifier and that you are expecting that you would always have records
numbered from 1 to whatever number. In Access when you start a record, in an
AutoNumber field, a new number is generated for that record. If you then
choose to delete that recrod, that number is never reused. Therefore, you
will have numbers missing. You should never try to equate the AutoNumber
field value with record numbers. In addition, if your recrods are sorted in
any specific order by any field, you would not have sequential numbers in the
AutoNumber field but you would still have records from 1 to whatever number.

If this does not address your specific issue, plese post back and someone
will be glad to try to help.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record Selectors - can it trigger a procedure 2
Speeding up "1 of X" 0
Using Record Selectors to transfer data between forms 2
Custom Record Selector Controls that don't work like the built-inones 1
Using Record Selectors 1
I want to use vba to set the form property to turn on and off the "record selectors" property 2
Subform causes Main Form to show the same record multiple times 9
Checking if Record Selector has the Focus 3

Top