Update Table with Option Group Label (1 Viewer)

[tanski811]

I have a unbound field form that I am using as a survey. For one example I have a question with several different optional answers (1=high, 2=medium, 3=low) How and where should I update my table with the actual answer if a user picks button 1, 2 or 3 to read in my table high, medium or low.

 

[WayneRyan]

tanski811,

Your table should have a numeric field to store the result from the
option group. The Option Group on your form should be bound to that
field.

Wayne

 

[tanski811]

Unbound fields

I used unbound fields in my form to keep users from using their mouse scroll button when moving up and down form. I set a control button marked "Submit Form" to update the underlined table with the form answers. Once updated the table reads the numbers. I need to know the best way to update the tables. I can use an update query but I was hoping there was a better way.

 

[WayneRyan]

t,

Since it's an unbound form, you have to use an Update query, or a recordset
to update the data in the underlying table.

There are other alternatives to disabling the Mouse Wheel though. Going to
an "unbound" form removes the ease with which you can develop/maintain
an application. It means a LOT more work for you and should be a last resort.

Have you used the Search Facility here to look for "Disable Mouse Wheel".
This is quite a common topic.

Wayne

 

[tanski811]

Thanks

I'll search the site for this topic. I can't believe such a small instrument can cause a boat load of issues.