Last record Problem

[GeoffO]

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

 

[AlanS]

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

 

[GeoffO]

Hi

How do you do that Alan?

Thanks

 

[AlanS]

In your VBA code:

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

 

[GeoffO]

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