default a combo box based on a message box

[Jollywg]

I have a combo box with 6 different options (opt1 ,opt2, opt3 etc). When the form first loads it asks a question and gives them a choice of answers (ans1, ans2) If they choose ans1 i want the drop down box to default to opt6, if they choose ans2 i want it to load normally. I thought i could just do this in the load section

if (ans1 = true) then
cbo1 = opt6
end if

thanks for any help

[ADezii]

[CODE=vb]
If (ans1 = True) Then
Me![cbo1] = "opt6"
Else
Me![cbo1] = ""
End If[/CODE]

[NeoPa]

Well, you're pretty well there as far as I can see anyway (other than the quotes of course) :

If ans1 = True then Me.cbo1 = "opt6"

You don't really want an ELSE clause.

[Jollywg]

Thanks for the replies...once i saw how to do it a big DUH! sign got slapped across my forehead.

Thanks a lot!

[NeoPa]

Hey, we've all been there you know :D