I have on a form an unbound combo box (cboPresetOption) to which I want to assign a value when the form opens.
The user can later change it, but I want to start with a value that I get thru a DLookup()
MY attempt at assigning the value to the control is not working, although the msgbox does provide the correct answer...
Your thoughts and suggestions woul dbe greatly appreciated in advance,
mark
-----------------------------------------
Private Sub Form_Open(Cancel As Integer)
vtext = DLookup("[PresetTitle]", "tbeFixtureSchedulePrintOptions")
MsgBox vtext 'this line is for debugging op
Me.cboPresetOption = vtext
Me.cboPresetOption.Requery
End Sub