ACCESS FEED: [MS_AccessPros] RE: Help with Yes/No boxes

Selasa, 10 September 2013

[MS_AccessPros] RE: Help with Yes/No boxes

How do I get it to filter the information into my reports. I don't see it in my query anywhere.

--- In ms_access_professionals@yahoogroups.com, <duanehookom@...> wrote:

Make sure the control wizard is turned on and drop an option group onto your form. You can pick a style to display buttons or check boxes. The Option Group control will have a value based on which option is selected. Each option has its own numeric value.

Duane Hookom MVP
MS Access

________________________________

> From: mahinalanibaker@...
>
> Yes I use the form to filter for my report. How would I do an option
> group? I'm sorry I'm just super new to access and I'm trying to figure
> it out.
>
> Thanks

> --- In ms_access_professionals@yahoogroups.com, <duanehookom@...> wrote:
>
> Is the form bound to a table or used for filtering a recordset? If
> there is only one option that should be selected, the standard solution
> is to use an Option Group.
>
> If you have separate fields for day and night, consider changing to a
> single "time of day" or "shift" field.
>
> Duane Hookom MVP
> MS Access
>
> ________________________________
>> From: mahinalanibaker@...
>>
>> I have a form with a few yes/no boxes. One option is day and the other
>> is night. If a user clicks on day is there a way for the night box to
>> become unavailable to select. Obviously if a job is completed in the
>> day it can't be completed at night. I think that a tool like this will
>> help eliminate data errors in my reports. Is soemthing like this
>> possible?