saving combox values 1

[jommyjet]

I imagine this should be pretty simple.
I'd like to save the source values in several combo boxes on closing a form. I set up a button that prompts a subroutine to save the value of a combobo, ie,

Private Sub closeform_click()
save1 = employeeone.Value
DoCmd.Close acForm, "employeeselect", acSaveYes
End Sub

and then call that value on opening the form like so:

Private Sub Form_Open(cancel As Integer)
employeeone.Value = save1
End Sub

I may be in excel vba mode and am not saving the value correctly in the first sub.
Any help I appreciate

 

[hneal98]

What version of Access are you using?

 

[jommyjet]

Access 2002
I should also mention that employeeone is the name of the control

 

[hneal98]

The value would be employeeone.seltext

 

[jommyjet]

thanks. that works great when the form is open, but on closing the form, all variables are lost.
I declared save1,... as public. is there something else I'm missing. Is it necessary to store the values in a table for later use?

 

[hneal98]

Once a form is closed, it no longer exists. If you want the variables to be saved, you would need to create a module to have them stored in. The module is global and exists until the application is closed. You could also save them in a table, but you don't want an cluttered information if you are not going to use the value for anything else.