Form Navigation?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Whenever I do a find in a form and move to another form it does not
take me to the same client that I had selected and I have to do another
Find to get back to the client I originally selected. How do I keep
the same client that is selected as I move from form to form?

I am new to Access just learning. Don't know code, but can usually
follow instructions.
 
Randy said:
Whenever I do a find in a form and move to another form it does not
take me to the same client that I had selected and I have to do
another Find to get back to the client I originally selected. How do
I keep the same client that is selected as I move from form to form?

I am new to Access just learning. Don't know code, but can usually
follow instructions.
Click to expand...

Your terminology might be confusing things. When you say "move from form to
form" do you actually mean moving from one "Record" to another within a
form? If so then "Find" is working as designed. You told it "find a
record" and it took you to the first record satisfying your criteria. If
you want to see ALL records satisifying your criteria as a set then you need
to apply a filter with that criteria instead. The Find tool is a "take me
to a record" action.

If that is not what you meant then you will need to clarify.
 
Whenever I do a find in a form and move to another form it does not
take me to the same client that I had selected and I have to do another
Find to get back to the client I originally selected. How do I keep
the same client that is selected as I move from form to form?

I am new to Access just learning. Don't know code, but can usually
follow instructions.
Click to expand...

Well, what you're asking does require some nontrivial code.

BUT... why move from form to form? Is there any possibility that you
could use a Form with a Subform, or perhaps with several subforms on a
tab control? A Subform automatically maintains this link without any
code at all; you'ld simply select the unique ClientID as the master
and child link fields of the subform.

One small worry I'm feeling here: are you storing the client name in
multiple tables? If so... DON'T. Store the name once, and once only,
and link to the Clients table by a unique ID if you need to see the
name.

John W. Vinson[MVP]
 
Back
Top