Solved SetValue (last entry) (1 Viewer)

[marion34s]

Hello Again,

This group has been super helpful in the past here's hoping for another!

I have a form that is used to enter new data - often times there is one piece of data (ProjectID) that is entered into the form 3-6 times in a row before having to enter a different ProjectID. Is there a way to make the last entered ProjectID to default into the ProjectID field? Here is a screenshot of the form:

Its a pretty simple form but this is an additional feature that my boss woud like to see on it and a few other forms as well.

Thank you in advance for your assistance!

 

[pbaldy]

One way:

Forms: Carry current value of a control to new records

I'd use the after update event of the project ID textbox.

 

[NauticalGent]

Try this

Microsoft Access tips: Assign default values from the last record

How to have form in a Microsoft Access database automatically offer to the values of the last record, to avoid typing similar data again.

allenbrowne.com

 

[NauticalGent]

Sorry Paul, you posted while I was responding!

 

[pbaldy]

No worries ET.

 

[marion34s]

One way:

Forms: Carry current value of a control to new records

I'd use the after update event of the project ID textbox.

Works great! Nice and simple - Thank you!

 

[pbaldy]

Works great! Nice and simple - Thank you!

Happy to help!