VBA Code Needed: Remove Filter, Go To Field, Find Record on Form

[amywolfie]

You'd think this would be easy, right? I am going to a subform which
takes the user to related records.

I also want to put a button on this form which:


1) Removes the filter (i.e.: goto related records)
2. Finds ALL records in the underlying table recordset
3) Goes to a field (County)
4) Performs a standard Access Find (Find Next)


I have tried quite a few techniques, and nothing fully works.


Thanks!


=====

 

[mike-strawberry]

Hi Amy,

Starting with 1) what filter is this? If you have a main form with a subform the subform normally shows records related to the record showing on the main form. If you move to a different record on the main form you get a revised set of related records in the subform.

If you want to see the type of records that are present in the subform - but all of them- then you need to find the subform in the objects list and open it directly from a button. That will work so long as the subform (query for) doesn't have a reference to anything on the main form within its criteria (wont have unless someone put one in there).

Not sure what you mean goes to a field - you may mean that you would like a choice list - eg click on a country to go to the records related to that country - that would be easy.

Standard find is available from the standard menu - or perhaps you need your own created finder. Probably easy to do.

Regards, Mike

 

[@Alex]

You'd think this would be easy, right?  I am going to a subform which
takes the user to related records.

I also want to put a button on this form which:

1) Removes the filter (i.e.:  goto related records)
2. Finds ALL records in the underlying table recordset
3) Goes to a field (County)
4) Performs a standard Access Find (Find Next)

I have tried quite a few techniques, and nothing fully works.

Thanks!

=====

Please show us your tests... we can help you to improve it...

@Alex