J
Jeff C.
I have a single table database to track student progress through a training
program.
I want to have some way of filtering only the records for a certain class or
trainer.
I like the Switchboard look and have tried several different ideas but have
not found one that does what I want it to.
In one case I designed the switchboard but bound it to the table, this works
as far as pulling up the form and filtering the records but it has the
drawback of being able to overwrite the table, this would perhaps ok if I
were the only one using the db but I know that once others use it they will
accidentally overwrite the class number or trainer name making a mess of
things. (I think this means I've created a subform not a switchboard?)
In a second version I have an unbound switchboard but when I try to create
buttons using the wizard I can never get them to open the main form and
filter it based on the class # or trainer criteria. I did try a select query
to filter the records and it works but it pulls up the query results in a
select table and won't give me an option to choose how I want the query run/
filtered.
I would like to keep it as simple as possible as my experience with Macros
and VBA is minimal at best.
What would be best is having it work like my first version but not
overwriting the original table screwing things up.
Thanks, Jeff
program.
I want to have some way of filtering only the records for a certain class or
trainer.
I like the Switchboard look and have tried several different ideas but have
not found one that does what I want it to.
In one case I designed the switchboard but bound it to the table, this works
as far as pulling up the form and filtering the records but it has the
drawback of being able to overwrite the table, this would perhaps ok if I
were the only one using the db but I know that once others use it they will
accidentally overwrite the class number or trainer name making a mess of
things. (I think this means I've created a subform not a switchboard?)
In a second version I have an unbound switchboard but when I try to create
buttons using the wizard I can never get them to open the main form and
filter it based on the class # or trainer criteria. I did try a select query
to filter the records and it works but it pulls up the query results in a
select table and won't give me an option to choose how I want the query run/
filtered.
I would like to keep it as simple as possible as my experience with Macros
and VBA is minimal at best.
What would be best is having it work like my first version but not
overwriting the original table screwing things up.
Thanks, Jeff