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