Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!



Access VBA - Sequential Numbering

By brian.ramshaw ·
Hi, I am new to the Access scene and would appreciate any help you could offer.
I have a very simple form containing 3 fields "project", "ID", "Ref"
The ID feild is the PK in a table "tblRaail"
What I require is to search the "Ref" per "Project" number and increment (+1) for a new record.

This is what I have come up with so far, but it returns nothing, please help.

NextID = DLookup("[ProjectNumber]", "tblRail", DMax("Ref", "tblRail") + 1)

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums