Access Check box and Option Button

[nimesh844]

Hello Friends Please Help me



I'm new to access. I have created table with following fields.
ID No, Name, Address, Gender, Favorite Food
I want to create form to insert data into tables. I have used option buttons for Gender and Check boxes for Favorite Food. But data didn't insert to the table specially option button and check boxes data didn't insert but other data successfully inserted into the table. Please someone help me
Thanks

Database1.accdb

Nimesh

[June7]

Is Gender a yes/no or text type? You have the option buttons in an Option Group control? The Group control is bound to Gender field? The Option Group control will take the value of the selected button. The values must be numbers (use -1 and 0 for Yes/No). If Gender is text type and you want to save F or M into Gender will require code. Otherwise, use a combobox with two choices.

Are you saving multiple values into Favorite Food? Check boxes will require VBA code. Otherwise use multi-select combo or list box. I NEVER use multi-value fields.

Advise no spaces or special characters/punctuation (underscore is exception) in names.

[nimesh844]

Thanks June7, Yes Gender is Text type.