A textbox or caption that remembers what I did just now

[Lifeseeker]

Hi,

I have an data entry form that users use to enter new record.

Since data entry is the main thing with this database, I would like to include a field or perhaps just a caption on the form that simply reminds users of the last PK they put in as they go enter a new record.

Users are spending a lot of time entering new record from paper-based files and it gets rather repetitious as the number of new records increases.

How should I go about implementing this feature?

On the form I simply want a text caption saying the last PK users entered. This PK is just what's in the first textbox on the form.

The other thing I should mention is that......I also have a "save" button on the form. When the button is clicked, it refreshes the form so that they can enter a brand new record. I don't want the caption to be erased.


Is this possible??

 

[missinglinq]

Not sure what you're doing to 'refresh' the form. Assuming this is a bound form, all you have to do to save a record and move to a new, blank record is simply move to a New Record.

DoCmd.GoToRecord , , acNewRec

Assuming you're doing something like that, to carry forward the last PK entered, add an Unbound Textbox to the form (I'd add it in the Header Section, to hold down confusion) and use code like this

Private Sub PKField_AfterUpdate()
 Me.PK_Reminder.DefaultValue = """" & Me.PKField.Value & """"
End Sub

where PKField is the Bound textbox that holds the PK and PK_Reminder is the Unbound textbox that displays the reminder.

Linq ;0)>