I have a table with an autonumber key value "RECNO". It's basically just a sequence number for the record. On the form for data entry to the table, RECNO is displayed, but there is no tab stop since the user won't need to change the value. I put an "add record" control button on the screen. When selected, a new blank record is displayed. However the RECNO field just displays "<autonumber>" and won't show a value until data is filled in on the first field in the tab order. Is there any way to get this field to fill itself in and display a value when adding a new record?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Displaying autonumber key value on form
- Thread starter elff
- Start date
- Status
Similar threads
- Locked
- Question
