Combo Box

[Bill]

Hi,

I may need your help.

I have a list of reports in a box when I don't select a report. It will
pop-up saying "Please select a report. This is fine.

I have two areas from Radio Button show All Groups or specific group. If I
forget to select on Radio button, I would like to see POP UP saying "Please
select one of two areas" from FRAME (Radio Button) before going to get a
report.

Your help would be much appreciated.
Thanks,

example:
If IsNull(Lists) Then
MsgBox "Please Select A Report"
Exit Sub
End If

'I don't know if I did the right thing..........
If IsNull(Frame) then
MsgBox "Please Select one of the Two Group"
End if

Dim stDocName As String

stDocName = Me!Lists

DoCmd.OpenReport "Report A", acPreview

 

[Jeff Boyce]

Bill

Another approach would be to "pre-select" one of the options for the user.
This would ensure there is always a selection made. Do you have a sense of
which of the choices is more frequently picked?

 

[Mingqing Cheng [MSFT]]

Hi Bill,

I am just checking on your progress regarding the information that was sent
you! Is Jeff 's suggestion is sufficient for you?If you encounter any
difficulty, please do not hesitate to let me know.

Please post here and let me know the status of your issue. Without your
further information, it's very hard for me to continue with the
troubleshooting. Looking forward to hearing from you soon.

Sincerely yours,

Mingqing Cheng
Microsoft Online Support