Selecting a Checkbox from a selection in a dropdown menu!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has one table (tblLog) connect to it. There is a yes/no
datatype as the 2nd column in a dropdown menu (from a different table called
"tblService"). When the yes/no is yes, I would like the check box to have
the yes value and vise versa. On top of that, from another dropdown menu,
there is another yes/no datatype in the second column. I need this dropdown
to update like the one before. Making the check box except the yes value
from either dropdown.

So yes on both dropdown menus would yeild yes to the checkbox.
A comination yes/no would yeild a yes for the checkbox.
And if both are no then the checkbox is false.
I hope this makes sense.

Then (if the check box is true) when they move to another record there is a
dialog box that yeilds a message (I know how to make a option box), but when
is closes it pulles up the "print" window. If the check box is null it
should go staight to the print window.

Thank you in advance!
James
 
James

I'm not sure I found a question in your post. If you are asking how to use
the selection of two combo boxes to determine what to do (or show), you'll
need to write a small procedure and call that procedure from the AfterUpdate
events of BOTH combo boxes.

The procedure could look something like:

blnDecision = True

If Me!cboFirst = False and Me!cboSecond = False Then
blnDecision = False
End If

This is, however, a gross over-simplification, just something to get you
started...
 
Back
Top