Can I open form "filtered" from Switchboard?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with an option group "ops" that has 5 options availale.
I would like to open the form with the approptiate switchboard with the ops option selected.

For example:
Switchboard button: Final Report
Open RptForm with control RptFrm.ops.value = 3
Result: RptForm opens with the "Final Report" optioon selected.

Any ideas?

Thanks,
 
if you want to FILTER the contents of the form, set the datasource of
the form to a query, where critera for feild "ops' is

=myswitchboard.ops.value

(myswitchboard is the name of your switchboard form)

or

if you want to open RptForm and then set a value you:

docmd.openform "rptForm"
forms!rptForm.ops.value = forms!myswitchboard.ops.value

is that what you're asking?

hth
blm
 
Thanks BrainlordMesomorph,
I used something similar to the second comment you left. I guess my
question wasn't to filter but to set the Option value.
In the OnLoad event of RptFrm I used
Me!ops.value = Forms!Switchboard.I
Where I comes from a function that I set up based on the recordset Item
Number from the switchboard form.

Thanks again.
 
Back
Top