Using Find (binoculars) on a subform

[efortin]

Hi,

In an HR application on MS Access 2003, I have a Job form that contains a subform for the child Incumbent record(s).

I would like to be able to find a job by searching for the incumbent's name, but cannot seem to do this in Access. The binoculars (Find) and filter do not succeed.

Is there a way to do this?

Thanks,
Elaine

 

[Adeptus]

I have done something similar just recently.

Make a new form, linked to the subform's data. I'm assuming this has a FK relationship with the main form's data.
Add a button to the main form to open this new form.
In the new form's Form Open event, run the search. This will find you the record so you can read the FK value.
In the new form's Form Close event, do a FindFirst on the FK value on the main form.

I hope I've explained that well enough

 

[efortin]

Finding main form record based on subform search

Hi Adeptus,

That was very, very helpful !

I ended up using filter instead of FindFirst and it works beautifully.

Thank you so much!
Elaine