RichO
Registered Yoozer
- Local time
- Today, 05:13
- Joined
- Jan 14, 2004
- Messages
- 1,036
I have a simple form and a subform within, for entering music from compact discs.
The subform has a text box for the track #, that I want to increment each time a new record is added, starting with 1 for the first record. Basically I want the number of each record in the subform to appear in the text box, and of course, when you advance a record in the main form, start back at 1 for the next CD.
I set the data type in the table to autoincrement but there are 2 problems. First, it prints (autoincrement) in the text box, and when you advance to a new record in the main form, the number doesn't go back to 1.
This is easy to do on a report but I can't figure it out in this form.
The subform has a text box for the track #, that I want to increment each time a new record is added, starting with 1 for the first record. Basically I want the number of each record in the subform to appear in the text box, and of course, when you advance a record in the main form, start back at 1 for the next CD.
I set the data type in the table to autoincrement but there are 2 problems. First, it prints (autoincrement) in the text box, and when you advance to a new record in the main form, the number doesn't go back to 1.
This is easy to do on a report but I can't figure it out in this form.