Re: change check box value based on combo box value



Do I understand correctly that when you select a value for Combo43 the value
is stored in the Boxes table, and that the check box values are stored in
the SampleData table? Are both of these table included in the form's record
source? Does the existing code compile correctly?
As I mentioned before, if the value of the Yes/No field can be dervived from
other data, the field is probably unnecessary.

"DrONDeN" <kenny.love@xxxxxxxxx> wrote in message
news:1186747260.245066.189440@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
BruceM

Combo box values are stored in a table (Boxes)
Check box values are stored in a seperate table (SampleData)

When 'Reference 1' is selected from the combo box, I want 'checkbox A'
to change from false to true.

When 'Quant 1' or 'Antenatal 1' is selected, I want 'checkbox B' to
change from false to true

When I inserted the code as mentioned before into the afterupdate
event, literally nothing happened. Ignore the checkbox numbers in the
code... they were for example only.

In the meantime, I will try the other solutions. Thanks guys.




.



Relevant Pages

  • Re: Help with macro to check validation rule
    ... By putting the code in the Exit event, the user can still check both ... If he checks the Female checkbox and hits TAB, ... text boxes, etc.). ...
    (microsoft.public.word.vba.general)
  • Re: Validation of multiple check boxes
    ... that would mean that more than 1 checkbox was checked. ... the check boxes were not blank. ... MsgBox "You haven't checked only 1 checkbox.", vbOKOnly, "Message ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: Validation of multiple check boxes
    ... that would mean that more than 1 checkbox was checked. ... Graham Mandeno ... the check boxes were not blank. ... MsgBox "You haven't checked only 1 checkbox.", vbOKOnly, "Message ...
    (microsoft.public.access.formscoding)
  • Re: CheckBoxes Stack up when Rows are hidden and unhidden
    ... I can now unhide the check boxes but I now want to differentiate between ... "Dave Peterson" wrote: ... I've created the check boxes from selecting them from the Control Toolbox ... The checkbox from the Forms toolbar does not allow this setting. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Form - Update Table - Click Event
    ... then I would argue that what you need instead of a checkbox is ... check boxes labels). ... Private sub cmd_Save_Click ... Dim strSQL as string ...
    (microsoft.public.access.forms)