Save form textbox values

[NISMOJim]

I'm working on a form for people to enter visitor request information for approval, with controls such as txtRequestorName, txtVisitorName, txtStartDate, txtEndDate, etc. I'm adding a command button at the bottom to request another visitor, which would close the form (save), and open again for the next entry. I would like most of the textboxes to autofill with the same information from the previous request, as most requestors have more than one person visiting in the same time frame. I think I could use a DLookUp to enter the values from the most recent entry in the table, but this is very slow. Is there a way to store the values of these textboxes in VBA, close the form without losing the values, open the new form in add mode, and pass those values to the proper textboxes? I think this would happen much faster than a DLookUp, but I don't know if it's possible. If so, do I save the date values differently than the string values?



As always, thank you for sharing your knowledge with the struggling masses.

[CJ_London]

you don't need to close the form and reopen it - just go to newrecord - and to pass the values tot he new record look at using the default value

This thread has a similar requirement to yours

http://www.access-programmers.co.uk/...t=defaultvalue

[Missinglinq]

You can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record.

Private Sub YourControlName_AfterUpdate()
   Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub

This syntax is valid for Text, Number, DateTime and Boolean Datatypes.

You’ll need to do this for each Control that you want to ‘carry forward.’

Linq ;0)>

[NISMOJim]

Awesome, you guys rock! Thanks again for all you do!

[Missinglinq]

Glad we could help!

Linq ;0)>