I have a form with two option groups in it. the results of the option button in these groups (three apiece) gets sent back to a table. my goal is to not allow a user to advance to the next page of the form unless a button is selected from both option groups. i have tried required fields in the table properties but it does not seem to work for me. i was then thinking it may need some expression typed somewhere that if this is "this" then this must be either "this". something along those lines...
Option Group Question
- Thread starter SoxPats83
- Start date
- Local time
- Today, 12:43
- Joined
- Sep 12, 2006
- Messages
- 16,053
assuming the option groups has values 1,2,3 etc, and there is no default then
if nz(group1,0)=0 or nz(group2,0)=0 then
msgbox("Please select choices from the option groups")
exit sub
end if
if nz(group1,0)=0 or nz(group2,0)=0 then
msgbox("Please select choices from the option groups")
exit sub
end if
exactly where in my VBA coding should i place this? your coding makes pretty good sense to me, but in your parenthesis, where it says "group1,0) is that the name of my option groun comma 0 or does that have a meaning?
