use option grp + combo to find record in other form

H

hjgwright

Registered User.

Local time

Today, 19:24

Joined

Jul 11, 2002

Messages

14

• Jul 31, 2002

• #1

Hi.

I want to set up a Find form for my db.
The Find form should contain an Option group with 'By First Name' and 'By Surname' as the options, and a Combo box which lists the names, by First Name or Surname depending on the selection in the Option group.

When I've chosen the person, I want to click on Find.
I want this to open my Personnel form (with all people's details) at the correct person.

I don't want the Personnel form to be filtered so that it only shows the selected person - I also need to be able to navigate through the rest of the personnel.

Thanks,
HW

 

Graham T

Registered User.

Local time

Today, 19:24

Joined

Mar 14, 2001

Messages

300

• Jul 31, 2002

• #2

HW

I have posted an example of something similar to what you are looking for.

The zip file contains the database (Access 2000) and a text file explaining the process.

The only thing that this does not do is present the form unfiltered, as basically when searching you usually want to find the record that you have searched for. You would therefore need to modify the process slightly.

HTH

Graham

 

Attachments

• combo_search_example.zip

  40.9 KB · Views: 205

H

hjgwright

Registered User.

Local time

Today, 19:24

Joined

Jul 11, 2002

Messages

14

• Jul 31, 2002

• #3

access 97....

Hi..
thanks for your reply.
I don't have a copy of Access 2000, though. Would you be able to send it in 97 format?

I have sorted out the form so that it is filtered, but I need to be able to navigate through the other people's details too, not just the filtered person.

Cheers.
HW

 

Graham T

Registered User.

Local time

Today, 19:24

Joined

Mar 14, 2001

Messages

300

• Jul 31, 2002

• #4

A copy of the same in Access 97

HTH

 

Attachments

• acc97_version.zip

  40.6 KB · Views: 169

H

hjgwright

Registered User.

Local time

Today, 19:24

Joined

Jul 11, 2002

Messages

14

• Jul 31, 2002

• #5

great... is there a way to remove the filter and stay on same record?

Hi..
That's exactly what I need to do.
Is there a way for me to say press the navigation button to go to the next record, which would remove the filter, but stay in the same place (i.e. not go back to the first record?).

Thanks again,

HW

 

Graham T

Registered User.

Local time

Today, 19:24

Joined

Mar 14, 2001

Messages

300

• Jul 31, 2002

• #6

HW

Once you've opened the form at the correct person, as defined by your search, clicking the remove filter button will then enable you to navigate through all records.

Once you've done what needs to be done, it wouldn't really matter whether you remained on the filtered record or not.

I don't know of any other way around this problem.

Graham