Access VBA - help with creating forms and coding

[bdub7989]

Hi, I am about as green as they come in using VBA and have encountered an area that leaves me scratching my head. Below is my situation and what I would like to do; I just don't really know how to get going.

I would like to create a form that allows a user to select one of five categories using radio buttons. Let's say Cat A, Cat B, Cat C, Cat D, and Cat E. Once they select the category they click a submit button that sets into action a query that will update the records in the "category" field of the table. So if they select Cat A, a query will then update all the records in the "category" field to "A".

How do I go about doing this? Mostly, I have no idea how to go about doing the coding. Thanks in advance for your help!

Regards,
Brian

[hyperpau]

Hi, I am about as green as they come in using VBA and have encountered an area that leaves me scratching my head. Below is my situation and what I would like to do; I just don't really know how to get going.

I would like to create a form that allows a user to select one of five categories using radio buttons. Let's say Cat A, Cat B, Cat C, Cat D, and Cat E. Once they select the category they click a submit button that sets into action a query that will update the records in the "category" field of the table. So if they select Cat A, a query will then update all the records in the "category" field to "A".

How do I go about doing this? Mostly, I have no idea how to go about doing the coding. Thanks in advance for your help!

Regards,
Brian

Let's say the name of your form where the radio button is found is "frmPets"
and the name of the radio button set is "rdoCategory"

On the Update To criteria of your query, use =[Forms]![frmPets]![rdoCategory]

Now that button of your form should be programmed to run the update query.
you can use access wizard to do this.