Manipulating Fields from Tables in Forms (1 Viewer)

[RadioProject]

I would like to be able to create a new ID Code from a "next available number" field in a "config" table. How do I extract this number from the table, use it in the form (ie in edit controls) and then calculate the next number and then put it back in the table ready for the next item that uses this number?

 

[Travis]

If using an autonumber is out try this:

dim lID as Long
lID = currentdb.Openrecordset("Select Top 1 [ID] from [config] order by [id] Desc").Fields("ID")

lID will now be the last ID number used in the config table. You can then manipulate away and then use code similar to this:

me.[ID] = lID