Auto populate

[Guest]

I'm building a data entry form with several pulldown lists. I would like
certain fields in the form to auto populate with the data from the previous
record with the ability to pick another value from the pulldown list.

I know the user can use Control ' but would like to automate the process.

Thanks in advance!!

 

[Guest]

If you ALWAYS want the values to follow the previous record you can update
the default value of the controls using the BeforeUpdate event of the form.

Me.MyTextBox.DefaultValue = Me.MyTextBox

 

[Guest]

Barry,

This is an untested idea, but worth a try. I think that if you put some
code in the After Update event of the form that would load variables with the
data from the controls. Then, in the Current event of the form, if there is
data in the variables, put the data in the variables into the controls.
Again, this is just a concept.