checkbox value based on other checbox values

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

mcnewsxp

within a given table, can access automatically set a checkbox to true if
other values are set?
without using a form and VB, i mean.

thanks,
mcnewsxp
 
I would think that this would have to be done using code and a form. Tables
don't really do much conditional setting of properties.

Rick B
 
Without a form or VB?

You can run an Update Query against your dataset, examine the value/s of
your fields, and accordingly set "Update" the value of your checkbox to True
or False.

hth
Al Camp
 
Rick B said:
I would think that this would have to be done using code and a form.
Tables
don't really do much conditional setting of properties.
Click to expand...

thought there might be a way to use a validation rule like a trigger or
something.
?
 
Not at the table level. Tables aren't designed to use for data entry, so
all the fancy stuff has to be done in a form.
 
AlCamp said:
Without a form or VB?

You can run an Update Query against your dataset, examine the value/s of
your fields, and accordingly set "Update" the value of your checkbox to
True or False.
Click to expand...

yeah, that's what i set up for the users.
they don't want to fool with that anymore.
guess i'll create a continuous form and add VB.
 
Back
Top