Requery text box based on check box selected

[anissw]

Good morning - Is it possible to have a query that will requery value of a check box based on which check box is selected? I have a form that has 5 check boxes and a text field for populating a unit price. When someone clicks a specific check box, the text field should display the unit price. I know how to accomplish this using a combo box and don't want to change the form to setup for a combo box, but rather use what everyone is currently used to. I want to add the check box is from 1 table linked to a form and the unit price is from another table not linked to a form. Both tables have 2 fields in each that will relate. I think this should be in vba but can't get the syntax in place and need help.

Thanks
anissw

 

[Uncle Gizmo]

Are the check boxes like an option group, where you can only have one selected, or are they independent?

 

[JHB]

... I think this should be in vba but can't get the syntax in place and need help.

Show the code you have.

 

[vbaInet]

Are the check boxes like an option group, where you can only have one selected, or are they independent?

Very important point. If they are in an option group then a radio button is preferable.

 

[Uncle Gizmo]

Very important point. If they are in an option group then a radio button is preferable.

Careful VB, that's very nearly a compliment!

 

[vbaInet]

Careful VB, that's very nearly a compliment!

Ha, just concurring. That was what I was thinking of asking before reading your post.

 

[anissw]

Hi everyone- I want to apologize for the delay in responding. I have been putting out fires on other projects. The check boxes are independent and wasn't necessary before except to categorize each if we required to look at previous choices, but now that I think about it, this can be utilized on a radio box.

I'll change the front end from separate check boxes to radio button. Afterwards, I should be able to requery without problems.

Thank you so much. I'll be in touch very soon of the status.