Show first free ID from table on my Form.

[natal7155]

Hi there.

I have a very simple dbase.

Table ( ID, name, surname , etc etc)
Form - I use this form to add new records to my table.

On this Form I should be able to see the ID number ( from next blank record)

So let say I have 1002 records on my table.So on my Form ( while I ma openineg to add new recrd) I sholud see ID=1003 ( so I should see next free ID number)

ID= autonumer


Any idea how to create this little button ( window)????

cheers
Dorota

 

[RuralGuy]

If you need to see the AutoNumber then you are not using the AutoNumber for its intended purpose. Having said that, an AutoNumber only gets a value when the record is dirtied.