radio button input name to table

[nishant.dhruve]

I want to Code my form in such a way that when i enter a value in text field it should take those values into tables related to field and crucial part for me is that when i select the radio button it should take label name of that radio button to the field related to it in table. image are shown below for form and table.Any can help please?

AS you can see in form there are three text values employee id, firstname, lastname and radio button on the top i want those radio button label for example general prod to be saved into the related field in the table.




This is my table

[ranman256]

Radio buttons are numeric NOT text.
Use a combo box for text values.

[ssanfu]

This is my table

Uh.... your attachments are not showing.....

[nishant.dhruve]

[ssanfu]

What you want is doable, but it will require some VBA.
I'm guessing that the options equate to the "AreaOfOper" field?

The options really should be in an Option Group because having them like the picture allows multiple options to be selected. An Option Group allows for only one option at a time to be selected.

Instead of an option group, you might consider using a list box.

So what is your process? Select an Area of Operation, Enter an Employee ID, First & last names, then click the Save button? If yes, is there code on the click event of the save button?

[Micron]

Looks like another double posting.
https://www.accessforums.net/showthr...657#post327657