Pull down for Option Group

[zat via AccessMonster.com]

I have a form that has three Option Groups that the user can select from to
produce a report. The first Option Group is TYPE (Frame73): Incoming,
Outgoing, TD. The second Option Group is STATUS (Frame 82): Open, Closed,
Not Required, All. The third Option Group is FILTER (Frame105): None, Admin,
Organization, Delegate. The only option group I'm having problems with is
the FILTER. Currently the user is selecting a filter option and having to
input the specific name into a window created from a query. I would like to
create a pull down for the user but am not sure how to do this. Thanks for
any help you can give me. This is part of the current code:

If Me.Frame73 = 1 And Me.Frame82 = 1 And Me.Frame105 = 1 Then
strWhere = "[dtmInRecDate]>=#" & Me.ActiveXCtl27 & "# And [dtmInRecDate]
<=#" & ActiveXCtl28 & "#"
DoCmd.OpenReport "rptInOpen", acViewPreview, , strWhere

ElseIf Me.Frame73 = 1 And Me.Frame82 = 1 And Me.Frame105 = 3 Then
strWhere = "[dtmInRecDate]>=#" & Me.ActiveXCtl27 & "# And [dtmInRecDate]
<=#" & ActiveXCtl28 & "#"
DoCmd.OpenReport "rptInOpenFilter", acViewPreview, , strWhere

 

[Nick 'The database Guy']

Hi Zat,

As far as I can tell you want to create a create a combo box for the
users this can be done relatively easily if you can find the table in
which the users profiles are stored. Then you have the option of using
the wizard (which I would only recommend if you are a novice) or
filling in the properties of the combo box yourself. Also I would
recommend that you start using some kind of naming disipline. Frame73
would become fraType, Frame82 becomes fraStatus and Frames105,
fraFilter.

Good luck

Nick

 

[zat via AccessMonster.com]

Hi Nick, 'The database Guy',
I can create a combo box with no problem but how do I get the user's
selection to filter the correct information from the table and generate a
report?

Hi Zat,

As far as I can tell you want to create a create a combo box for the
users this can be done relatively easily if you can find the table in
which the users profiles are stored. Then you have the option of using
the wizard (which I would only recommend if you are a novice) or
filling in the properties of the combo box yourself. Also I would
recommend that you start using some kind of naming disipline. Frame73
would become fraType, Frame82 becomes fraStatus and Frames105,
fraFilter.

Good luck

Nick

I have a form that has three Option Groups that the user can select from to
produce a report. The first Option Group is TYPE (Frame73): Incoming,

[quoted text clipped - 19 lines]