Yes/No Question on a form and make it required field

[Sed]

Calling out to all Access Guru, I'm stuck once again. In my Shipment detail table, I have a field called "Are_the_parts_being_sold?_Yes and "Are_the_parts_being_sold?_No" Format as "Yes/No" respectively. On my form, I ask the question "Are the parts being sold?" then I have a "Yes" and "No" for them to choose. Then I want those field to be required.

I think you guys know what my delima is...can someone please help.

thanks

 

[Alansidman]

Am I understanding you correctly? Do you have two fields in your table and only one control on your form. All are Yes/No? If this is the case, why not only one field with the Yes/No option bound to the control on the form? You only need to have one field, you can then query for only Yes or No.

As to then making the entry required, for the field in your table, in the properties section at the bottom, where it states Required, make it Yes. This will then make the control required in your form.

Alan

 

[Sed]

Alan, you understand me correctly. I tried to build this first before I ask question, thats the reason why I have 2 fields. I'm fairly new in in access, but I'm learning fast. I've never done this tasks before and it was ask by my boss to see if its possible. Having said that, please have patient with me.

I'm not sure if I understand you correctly, Please walk me through this. Right now I understand that I should only have one field and the format is Yes/No.

 

[Sed]

Alan,
My objective on the form is to ask the question with a "yes" or "no" answer. However, they have to fill in "yes" or "no" answer before they proceed to the entry. My thoughts is that if you have only one field and only one checkbox if the answer is "yes", then what if the answer is "no" OK, lets assume I ask the question, "Are you married?" and the only option I have is "yes" if the box is checked and "no" if the box is not checked. Now, how can I make that field required if we let an unchecked box be "no"?

 

[option]

You could do two yes/no boxes: 1 = Parts Shipped, 2= Parts Not Shipped and then follow the same steps as your previous thread, http://www.access-programmers.co.uk/forums/showthread.php?t=162554

 

[missinglinq]

This is the classic scenario for using one field, in the table, and a two checkbox Option Group, with the OG's Default set to No. You then tie the Frame for the Option Group to your underlying field.

 

[Alansidman]

Missingling has nailed this one. One field and use the option group with radio buttons or option boxes. Alternatively, you could accomplish the same with a combo box. It is really a personal preference, but I would stay away from two fields.

Alan

 

[Sed]

You guys are the best!!! Thank you very much. Happy New Year!! to all with wishes of good health and hope you win the lottery.