best way to use same form with different criteria

[Klatuu]

Nothing really wrong with using a filtered form. You may consider a bit
different approach. If you can use one form rather than multiple indentical
forms with different filtering, you would save yourself a lot of maintenace
grief.

For simplicity's sake, you might consider just adding an unbound combo box
to your form in the form header that produces a list of the values on which
you want to filter. Then use the combo's After Update event to filter the
form with the user's selection.
--
Dave Hargis, Microsoft Access MVP

Hi Dave,
Basically, I can do every thing from the MainForm, the filtered versions
allow me to focus easily on the data for a particular page (tab) when the
form is opened from the switchboard. Since I'm a biologist & not a database
person I thought it might be easier than filtering the form everytime.
My database is fairly complex & remains a work in progress that I continue
to tweak. I'd love to have a 'real' database person take a look at it & help
me work out the bugs; but so far no takers. The scary thing is that as I
learn more about database design, I realize it could certainly be greatly
simplified & is probably dirtier than I even know. -- ^^0^^
Thanks for you help,

Laura S Finn
Fly By Night, Inc
www.flybynightinc.org

No, you can't use wild cards when referencing controls and subforms. They
must be explicit.

Can you provide a bit more description. What is it that is different about
your two forms?
--
Dave Hargis, Microsoft Access MVP

I have a similar switchboard issue -- my initial solution was to save the
form with a new name i.e MainForm & FormCriteria1. It works, but is there
anyway to associate the controls and subforms with the new form without
having to change all of the form name references.? Can I use a wildcard for
the form name so it will work on both MainForm and FormCriteria1??

Here's a general description of my database ------ My main form has several
tabbed pages each with 1 - 3 subforms and one of more command buttons. A
command button located on a tabbed page is set to open a form using an
embedded macro for the onclick as follows =
[ProjectID]=[Forms]![MainForm]![ProjectID]. I am using Access2007 (recently
converted from 2003).

Hope this makes sense, this is my first post to any newsgroup and my
database knowledge is minimal at best. The info I've gleaned from this group
has been a huge help ---

--
Laura S Finn
Fly By Night, Inc
www.flybynightinc.org


:

Hello I'm building an App that uses the switchboard functions of access. I
have a form that can be opened from the switchboard. This forms recordset is
a query with the criteria on one field set to "is not null". I would like to
have a second button on the switchboard that would open the same form, but
change the query's criteria to "is null". How would be the best way to
accomplish this?

v/r
john

 

[Laura Finn - Fly By Night]

Thanks Dave,
I'll give that a shot -- appreciate your input

--
Laura S Finn
Fly By Night, Inc
www.flybynightinc.org

Nothing really wrong with using a filtered form. You may consider a bit
different approach. If you can use one form rather than multiple indentical
forms with different filtering, you would save yourself a lot of maintenace
grief.

For simplicity's sake, you might consider just adding an unbound combo box
to your form in the form header that produces a list of the values on which
you want to filter. Then use the combo's After Update event to filter the
form with the user's selection.
--
Dave Hargis, Microsoft Access MVP

Hi Dave,
Basically, I can do every thing from the MainForm, the filtered versions
allow me to focus easily on the data for a particular page (tab) when the
form is opened from the switchboard. Since I'm a biologist & not a database
person I thought it might be easier than filtering the form everytime.
My database is fairly complex & remains a work in progress that I continue
to tweak. I'd love to have a 'real' database person take a look at it & help
me work out the bugs; but so far no takers. The scary thing is that as I
learn more about database design, I realize it could certainly be greatly
simplified & is probably dirtier than I even know. -- ^^0^^
Thanks for you help,

Laura S Finn
Fly By Night, Inc
www.flybynightinc.org

No, you can't use wild cards when referencing controls and subforms. They
must be explicit.

Can you provide a bit more description. What is it that is different about
your two forms?
--
Dave Hargis, Microsoft Access MVP


:

I have a similar switchboard issue -- my initial solution was to save the
form with a new name i.e MainForm & FormCriteria1. It works, but is there
anyway to associate the controls and subforms with the new form without
having to change all of the form name references.? Can I use a wildcard for
the form name so it will work on both MainForm and FormCriteria1??

Here's a general description of my database ------ My main form has several
tabbed pages each with 1 - 3 subforms and one of more command buttons. A
command button located on a tabbed page is set to open a form using an
embedded macro for the onclick as follows =
[ProjectID]=[Forms]![MainForm]![ProjectID]. I am using Access2007 (recently
converted from 2003).

Hope this makes sense, this is my first post to any newsgroup and my
database knowledge is minimal at best. The info I've gleaned from this group
has been a huge help ---

--
Laura S Finn
Fly By Night, Inc
www.flybynightinc.org


:

Hello I'm building an App that uses the switchboard functions of access. I
have a form that can be opened from the switchboard. This forms recordset is
a query with the criteria on one field set to "is not null". I would like to
have a second button on the switchboard that would open the same form, but
change the query's criteria to "is null". How would be the best way to
accomplish this?

v/r
john

 

[Klatuu]

Okay, post back if you have any problems with it.
--
Dave Hargis, Microsoft Access MVP

Thanks Dave,
I'll give that a shot -- appreciate your input

--
Laura S Finn
Fly By Night, Inc
www.flybynightinc.org

Nothing really wrong with using a filtered form. You may consider a bit
different approach. If you can use one form rather than multiple indentical
forms with different filtering, you would save yourself a lot of maintenace
grief.

For simplicity's sake, you might consider just adding an unbound combo box
to your form in the form header that produces a list of the values on which
you want to filter. Then use the combo's After Update event to filter the
form with the user's selection.
--
Dave Hargis, Microsoft Access MVP

Hi Dave,
Basically, I can do every thing from the MainForm, the filtered versions
allow me to focus easily on the data for a particular page (tab) when the
form is opened from the switchboard. Since I'm a biologist & not a database
person I thought it might be easier than filtering the form everytime.
My database is fairly complex & remains a work in progress that I continue
to tweak. I'd love to have a 'real' database person take a look at it & help
me work out the bugs; but so far no takers. The scary thing is that as I
learn more about database design, I realize it could certainly be greatly
simplified & is probably dirtier than I even know. -- ^^0^^
Thanks for you help,

Laura S Finn
Fly By Night, Inc
www.flybynightinc.org


:

No, you can't use wild cards when referencing controls and subforms. They
must be explicit.

Can you provide a bit more description. What is it that is different about
your two forms?
--
Dave Hargis, Microsoft Access MVP


:

I have a similar switchboard issue -- my initial solution was to save the
form with a new name i.e MainForm & FormCriteria1. It works, but is there
anyway to associate the controls and subforms with the new form without
having to change all of the form name references.? Can I use a wildcard for
the form name so it will work on both MainForm and FormCriteria1??

Here's a general description of my database ------ My main form has several
tabbed pages each with 1 - 3 subforms and one of more command buttons. A
command button located on a tabbed page is set to open a form using an
embedded macro for the onclick as follows =
[ProjectID]=[Forms]![MainForm]![ProjectID]. I am using Access2007 (recently
converted from 2003).

Hope this makes sense, this is my first post to any newsgroup and my
database knowledge is minimal at best. The info I've gleaned from this group
has been a huge help ---

--
Laura S Finn
Fly By Night, Inc
www.flybynightinc.org


:

Hello I'm building an App that uses the switchboard functions of access. I
have a form that can be opened from the switchboard. This forms recordset is
a query with the criteria on one field set to "is not null". I would like to
have a second button on the switchboard that would open the same form, but
change the query's criteria to "is null". How would be the best way to
accomplish this?

v/r
john