Insert a unique and autoincrementing value from an unbound form

[Richie27]

Hi all,

I have a table called actions with various fields like pkFileAction,actionDesc, actionDate, actionReason, actionInstance etc.

There are times when I will want to input multiple values, as many as ten, into this table from an unbound form.

In the actionInstance field I want to record a number which uniquely identifies that input instance.

The first instance of say, ten files being recorded will have an actionInstance value of 1 and the next instance of say one file will be recorded as 2 and then 3 and so on..........

I need to be able to uniquely identify each instance of records being inserted as a unique event. The autoincrement pk field won't work as it stores an id for each of the files - and I want to record the same number for things that happen at the same time.

Hope that is clear.



Rich.

[Robeen]

I think what you can do is use a DMax() function to get the previous highest number from the actionInstance field & increment it by one.
Eg:

NewactionInstance = DMax("actionInstance", "YourTableName") + 1

Where NewactionInstance is a numeric variable to hold the new actionInstance for the current number of entries.
Then - use NewactionInstance for every new record you enter.

Each time you enter an instance, you will get a number one up from the highest action instance number in there.

Does that help?

[Richie27]

Ya, thank you.