<<Viewed Record Question>>

  • Thread starter Thread starter Adam Gresham
  • Start date Start date
A

Adam Gresham

In my database I have a subform(ACCOUNT) embedded in a larger form(CLIENT).
For each Client there may be several accounts. The problem is this:
After I enter in the information into the fields, and run my
update query, the form and subform are refreshed to viewing
the first account for the first client (so basically if I just
created my 5th client's 3rd account, after the update query, the
form goes back to my 1st client's 1st account). Is there any way, be
it through SQL, VBA, or a query of some kind, that I can view the
record I just entered instead of having to search through my form
for it?

Thanks!

Adam Gresham
Conquest Communications Group
(e-mail address removed)
 
They refresh automatically.... I don't know how to manipulate which
form/subform refresh's and which doesn't.

If it is any help, what I called my update query is actually a macro that
runs a series of update queries. It looks like this:

SetValue
SetWarnings
Close
OpenForm
OpenQuery
OpenQuery
OpenQuery
OpenQuery
SetWarnings
GoToRecord <<Should this be in a different place or something? Should it not
be there at all? I don't know.

Basically we are stumped over this one. Thanks for your time! :)
 
Back
Top