This is not one I specifically built, but one I am addiing to. It is totally
homemade and not an Access Switchboard. Sorry for the confusion.
I would use an Option Group and a command button.
The Option Group would have 3 buttons, one for each location and would
return 1,2, and 3 respectively.
The command button would open the form using the Where argument of the
OpenForm method to filter the form's records based on whatever field in the
form's recordsource that ldentifies the location. For example purposes, I
will assume the field identifying the location is [Location] and that the
values for the locations are Denver, Chicago, and Dime Box (a small down in
SE Texas :)
The command click event would then be something like:
Dim strWhere As String
strWhere = "[Location] = """
Select Case Me.opgLocation
Case 1
strWhere = strWhere & "Denver"""
Case 2
strWhere = strWhere & "Chicago"""
Case 3
strWhere = strWhere & "Dime Box"""
End Select
Docmd.OpenForm "HelpDesk", , , strWhere

Signature
Dave Hargis, Microsoft Access MVP
> This is not one I specifically built, but one I am addiing to. It is totally
> homemade and not an Access Switchboard. Sorry for the confusion.
[quoted text clipped - 13 lines]
> > > Can someone simply this for me please?
> > > Thanks so much.
Johnny - 22 May 2008 18:21 GMT
Klatuu,
Thank you so much. You have always helped me in a bind. I was going in the
right direction with the group and buttons, but did not have the right coding.
You're the best.

Signature
Johnny
> I would use an Option Group and a command button.
> The Option Group would have 3 buttons, one for each location and would
[quoted text clipped - 41 lines]
> > > > Can someone simply this for me please?
> > > > Thanks so much.
Klatuu - 22 May 2008 18:24 GMT
Thanks for the kind words, Johnny. Glad I could help.

Signature
Dave Hargis, Microsoft Access MVP
> Klatuu,
>
[quoted text clipped - 48 lines]
> > > > > Can someone simply this for me please?
> > > > > Thanks so much.
Jan Baird - 27 May 2008 20:50 GMT
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.