Hi

I have a textbox on a form which displays the number of the last record entered.

=Last([Table1]![ID Number])

Then problem is when I enter a new record and save it, the last record field
doesn't update until I close the form and re-open it. How do I make it update
automatically?.

Geoff

Have you tried explicitly using the Requery method of the text box (or of the form) after the new record is saved?

Hi

How do you do that Alan?

Thanks

In your VBA code:

MyTextBox.Requery 'requery text box
Me.Requery 'requery current form

Thanks Alan

I managed to get it to work before I read your post by changing the textbox to a listbox then refreshing the form on the save record form.

I will try your way as a textbox looks better than a list box.

Thanks

Geoff