Find prev record on other requeried form

[Anthony Fontana]

Using access 2003. I have a main form for name and address info. A subform
shows limited info on client placement.

Click a command button on the main form and user opens another form for full
screen entry of placement data. That form opens showing the client selected
on the initial main form.

When the full screen placement form closes, it requeries the original main
form with the placement subform to show the added placement. It goes to the
first record in the table though. It does not show the original client whose
placement was just added.

How do I set the main form to go to the client previously shown before the
requery on the linked form.

Thanks in advance.

 

[KARL DEWEY]

Click a command button on the main form and user opens another form for full
screen entry of placement data.
Have that button to store the record information such as ClientID (primary
key) somewhere using SetValue. Then on close of full screen placement form
have it requery and FindRecord = ClientID.

 

[Jeff Boyce]

Anthony

In order for your first form to reset itself and point at a different
customer, there must be something in either event procedures or the
properties of the form that's telling it to do so. Access doesn't do that
kind of thing without orders...

Any chance there's an event procedure (or many) associated with the form?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.