[AccessD] Access 2007 - acCmdFind problem

The project I am working on administers a questionnaire to students in an
attempt to bring down the attrition rate.

The questionnaire is designed and administered by one or more researchers.

The questionnaire is not static. that is the researcher can add, delete or
modify the questions at any given time.

This allows the researcher to place a question anywhere within the
questionnaire.

There are 20 different types of questions, e.g. true/false, scale (1-10 or
1-100), 4 point Lickert type, etc.  

The researcher can change the text of each response in a question as well as
change the text of the question.

We are currently going through usability testing.  The entire "class" is
around 500 students.  The class has a 3 digit identifier that is used in the
questions.  There are about 350 questions in the current questionnaire.

 

The researcher uses a Question  form to modify the questions.  The question
form has a sub form that shows an example of the question as it would look
on the questionnaire.  When a search is done using a list box for combo box
the sub form changes to reflect the text and  type of question.  When the
question type changes the sub form updates the sample. For example a
question might change from a fill-in question to combo box self-lookup
question OR a question might change from a 4 pt multiple choice to a 4 pt
Lickert type question.

 

Here are my questions:

 

Question #1:

As I mentioned above the class has a 3 digit identifier embedded in some
questions.  The researcher puts this identifier within the question to
personalize it for the students.  I have a button on the question form that
is used to search for questions with the 3 digit class identifier.  I use:
DoCmd.RunCommand acCmdFind because, the 3 digit class identifier will need
to change periodically and this allows the researcher to do a "replace all"
after the search.

 

I cannot figure out how to update the sample question sub form after the
"Find Next" button is clicked on the Find dialog box.

Does anyone know how to run a custom function  (update sub form) while the
dialog box is still open?

 

Question #2:

When the search button on the question form is clicked, I use SendKeys to
ensure that "Match" is set to "Any Part of Field" and that the cursor goes
to "Find What" field.  That works, however, occasionally the Num Lock key is
turned off.  I understand that I could use: Application.SetOption "Default
Find/Replace Behavior",1 - but that would set it for all users.  Is there
some way to achieve the same functionality without using SendKeys?

 

Thanks in advance,

Jim