Help with Popup Form

[FFischer]

Hello Developers

I need to create a form in Access that will ask the user for Division (3-Letter Abbreviation) State (2-Letters) and Initials (2 letters)
This info will then be passed to variables in VBA

I need for the form to remember the last entries that were submitted:

For example

Division: WST
WST was the last entry for Division, but the user needs to have the option to enter CNT

State: CA
CA was the last entry... and so forth

How can I set the default entries to be the last data that was input?

Thanks

 

[ranman256]

you can save the last entered value in the .TAG property of the control.
cboState.tag = cboState

i have a tClientDefault table to store these for later.
when the user closes the screen, post the values to the table (update query)
in the Form_Close() event, run the update query to save the values.

in the form_Open event, load the defaults from the table
cboState.tag = rst.State
cboState = rst.State