Filter affecting DoCmd.FindRecord

T

Tucker

Hi all,

I have a database being used as a process manual. On my main form
Frm_MainForm is a free text field LinkedInfoPage1. When I click on what is
entered in this field (It is the Title of another page) the Frm_MainForm
remains but the data (or record) changes.
This is just what I want it do do! (Finally figured this one out!!!)

However it only works when all records are being viewed (unfiltered).
The trouble is users will be accessing the form from a keyword search screen
which filters the main form as 1 of 1. Thereby making my code below stop
working.

Private Sub LinkedInfoPage1_Click()

DoCmd.GoToControl "Title"
DoCmd.FindRecord LinkedInfoPage1

End Sub

When I place a simple filter=false code in this it takes the records back to
1 thus missing whatever was entered into the "LinkedInfoPage1" field on the
record being viewed.
Any ideas????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top