Form "Get Last"

[Guest]

I process a new record every 30 seconds. Half of the forms field entrys are
repetitively the same. Rather than let my hired help go into the "DEFALT"
settings and edit it, I'd rather the form recalled the last entry from the
first record in the current run.

We process/induct a new group of cattle with new "Pen #'s", & "Tag Colors"
etc. and wouild like to enter the appropriate info/data with the first record
today and have the form recall those field entrys from the first record today
and each subsequent record (field specific) until we are done the batch run.

 

[Steve Schapel]

Rusty,

On the After Update event of the form, you can put code like this...

Me.Pen_No.DefaultValue = Me.Pen_No
Me.Tag_Color.DefaultValue = """" & Me.Tag_Color & """"
etc.

The syntax I have used in this example assumes that Pen No is a number
data type and Tag Color is a text data type.

Note also that I have used Pen No instead of Pen # - it is not a good
idea to use a # as part of the name of a field or control.