using filters in switchboard

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

Guest

I am creating a big project that will allow my company to access member
information. I want to use a switchboard so that this is more user friendly
to those who will be using it. In the switchboard I want there to be command
buttons to open and view member information and another to add member
information. I have all of that created so far. My problem is: I want to
apply a filter onto the command button of opening and viewing member
information. This way, my users can click the command button, a screen will
come up and ask what they want to look for, they will tape in that member's
name and their 'file' will be pulled up.
Is this impossible?
 
hi,
I've never heard of doing that with a filter but i suppose
it could be done. since your are using the word filter, i
assume you only have 1 table.
what i use is a criteria form. have the button on your
switchboard open the form.
the criteria form would have text boxes for name, other
and maybe checkboxes or options buttons to select what you
wanted to see. each checkbox would have it own query
assuming you wish to see data in different ways. depending
on what info you pull, each query may have it's own
report. or if you don't want the report, just have the
query come up in data sheet view.
but what i am discribing here may be more complex that you
want. maybe you could get by with a text box for name and
a go button.
 
Hi Shannie,
I do something similar with my customer list.
I have a separate form for viewing/editing customer information.
In your case substitute "member" for "customer".
On my MainMenu (switchboard) I have a combo box that selects CompanyID,
CompanyName, CompanyStreet, CompanyCity and CompanyState.
In the afterupdate event of the combobox I have code that opens the customer
form to the customer name selected.
I also have a command button that opens the customer form to a new record.

That might work for you.

Mike
 
Back
Top