<<Viewed Record Question>>

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)
 
A

Adam Gresham

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! :)
 

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

Similar Threads

Adding data to MS Access from csv file 0
New computer, how do i move outlook 365 ENTIRELY? 0
Access 2010 DB not fuctional with multiple users 2
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Datasheet combo box empty 1
A Form that leads to a second Form 2
Refresh field 0
how to merge mult records into a single record 2

Top