displaying next cell ID on access

Got it!.... Thank you very much. As simple as this seemed it made world of difference in my app.

So let's just say I want to make my life difficult.....
I'm still open for an answer if anyone knows a way.

If you can explain what you are trying to do, we maybe able to provide
some better ideas to accomplish it.

You can get the highest ID currently in the database with the following
select.

SELECT max(IDField)
FROM aTable

You could then assume that the next number used will be one higher then
this number. Of course that will sometimes be a wrong assumption. If
one more more records that came after the current max id have been
deleted the auto number will not reuse their id values, but rather use
the next value never to have been assigned.

You did say you wanted a difficult life.

So let's just say I want to make my life difficult.....
I'm still open for an answer if anyone knows a way.

If it's an autonumber in your db, you don't need to know the next value in advance in order to enter a record. If you need the value for anything else, it's better to get it after the insert.

For the application I'm running, I would need to know the ID number or at least a tag number of some sort while I'm entering the data. Even if it's a bad idea. Is there a way to display "the next ID number or any number for that matter" incremented on a form that insert information on the table.

I'll take suggestions aswell if you kow better ways of tagging entries while entering them

Yes you can, but it's a bad idea so why bother?