initiating a value for a combobox

[markjkubicki]

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

[NTC]

try this:

Me.cboPresetOption.value = vtext

and eliminate this line which I believe undoes the previous line....
Me.cboPresetOption.Requery

off the cuff - hope it works.....

[markjkubicki]

tried both your suggestions, which to me seemed like a latenly obvious solution (which I completely missed)

also tried Me.cboPresetOption.defaultvalue = vtext

alas... it's still not good

[RuralGuy]

The Open event is too early in the process to reference a control on the form. Use the OnLoad event instead.

[markjkubicki]

sorry, that's not it either (does it matter that the control is on a page of a tab control ?)

[RuralGuy]

No! Each control on a TabControl has a unique name and referencing them does not include the TabControl. Doesn't work huh, hmm?

[markjkubicki]

got me perplexed too...

[RuralGuy]

Does the form have a RecordSet? Try using the Current event if it does.

[markjkubicki]

didn't work either (hmpft !!!)

[RuralGuy]

Have you got a little sample you could post so we could play?

[markjkubicki]

not sure how to do that
(sorry, self-taugh newbie here)

[RuralGuy]

Use the Post Reply button and scroll down to Manage Attachments.

[markjkubicki]

got that part, just not sure what to attach...
if i exported the form, would i need to export if to a new database? what would happenn to all of the tables associated with it?
should i simply send you screen shots of the form and it's code?
...and so forth

[RuralGuy]

Import just what you need into a new db.

[markjkubicki]

like this? (see aattached)

it doesn't seem like the back-end linked tables required for this form to open are working?
(even though I've included them in the import)