jimsterman82
New member
- Local time
- Today, 07:41
- Joined
- Apr 16, 2019
- Messages
- 5
Hello,
I am looking to auto-increment a part number every time the New Part number form is opened. I am trying to use the default value of the Part Number field in my form for this.
Will an input mask interfere with this?
We are moving data over from an old spreadsheet and so many part numbers exist. This has caused the autonumber option to be out of the question.
My challenge is: our part numbers include letters (ex. SM-004112)
Out of desperation to get things moving I have set up a query to show the last drawing number entered and have included an instruction on the table to type in the number after the one shown (The number from the query is shown in text next to the data entry field).
I have been reading articles for several days no to no avail. It has been many years since I set up a database and have lost much of my original knowledge.
Please help!
I am looking to auto-increment a part number every time the New Part number form is opened. I am trying to use the default value of the Part Number field in my form for this.
Will an input mask interfere with this?
We are moving data over from an old spreadsheet and so many part numbers exist. This has caused the autonumber option to be out of the question.
My challenge is: our part numbers include letters (ex. SM-004112)
Out of desperation to get things moving I have set up a query to show the last drawing number entered and have included an instruction on the table to type in the number after the one shown (The number from the query is shown in text next to the data entry field).
I have been reading articles for several days no to no avail. It has been many years since I set up a database and have lost much of my original knowledge.
Please help!