How does a form remember values in cbo box when new form is selected?

[cavery]

Hello,
Basically, I have a form (frmTest) that has a combo box with model names. If I select for example model A from the combo box, then push a command button to view another form, when I return back to my original form (frmtest), I would like the same model A to be displayed, so the user wont have to search for the same model again.

How can I achieve this? I've tried a DLookup but I keep getting errors.

Any help would be appreciated!
Thanks,
Clark

~Clark

 

[HNA]

Hi,

Simply Store The Value Of The Combo Box After_Update The After Docmd.OpenForm Return The Stored Value To The Combo Box.

Regards

" Åä Çááå íÍÈ ÅÐÇ Úãá ÃÍÏßã ÚãáÇ Ãä íÊÞäå "

 

[cavery]

Thanks for the reply, I tried to do something like this:

Private Sub cboModelName_AfterUpdate()
Forms.frmProbUpdate.cboModel = Me.cboModelName.OldValue

But still receiving errors...I dont think I use the Docmd.Openform because I'm actually accessing the same form.


Any suggestions?
Thanks,
Clark

~Clark