Create autonumber button in form - tables ready

[magj]

Hi,

I have a form to add new records to a table(s), which have already the autonumber field.
All I want to do is to create a button in the form that generates and shows the autonumber of the new record being added.

I have zero experience in VBA. I have already googled a lot, but couldn´t get to anything.

Thank you in advance.

[jzwp11]

If your form is bound to the table, Access will automatically generate the autonumber field's value when you start entering data into one of the other controls on the form. You would need to include a textbox control on the form for the autonumber field in order to see the value.

[magj]

Thank you.

[jzwp11]

You are welcome.

[magj]

Another simple thing. I noticed I won´t be able to save the new record if the auto-number has not been generated yet.
And in this template which I am adapting, I want, therefore, to configure a button to generate the autonumber, which is then shown in the textbox I created.
I have been trying hard to find something I can understand..
Can you give a hint?

Thanks

[jzwp11]

Another simple thing. I noticed I won´t be able to save the new record if the auto-number has not been generated yet.

I'm not sure I follow. The autonumber value should show as soon as you start entering data in any other control on the form. The record is not saved with that autonumber value until either the user has tabbed through all the controls on the form or until one of the record navigation buttons has been clicked (forces a save of the current record). Are you trying to create new records without any data except the autonumber? If so, why?

[magj]

Ok. It seems the problem is that the autonumber is not generated when I click the new record button and start filling the several fields.

[jzwp11]

It should be, so something else is going on. Can you zip and post your database (with any sensitive data removed or altered)?