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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filling in a field automatically

Status
Not open for further replies.

amberlynn

Programmer
Dec 18, 2003
502
CA
How can I have an 'ID' field on my form auto-populate based on the month & year from another field (date field), and then an integer, incremented by one, from the last record, which contained the same month/yr.
So, if there are 3 records that were created in November, the 'ID' field would be 11-07-01, 11-07-02, 11-07-03? If a new record was created in Nov, it would be 11-07-04...
I have no problem getting the month & year to populate, but can't figure out how to have it look up existing records to see what the last integer was, and increment it by one...
Any suggestions?
Thanks!
Amber
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top