Newbie..need help...form design

[dridge]

I have a data base with COMPANY NAME in it. I have a Combo box on my form with company name in the drop-down. How can I display a Yes/No field on my form based on what I select on the COMPANY NAME selection...Any help would be greatly appreciated!!

 

[Lightning]

Use some code in the "On Change" event of the combo box to set the Yes/No field to what you want it to be. Something like:

If [combobox] = "some value" Then
[Yes/No Field] = 1
Else
[Yes/No Field] = 0
End If

If you have many values to consider, you could also use a Select Case statement.

Hope this helps

Lightning