refresh form based on query

  • Thread starter Thread starter McLean J
  • Start date Start date
M

McLean J

I have a form based on a query of two tables, the main one
being "tblOrder"
I have a button on that form that i'm using to basically
duplicate part of a record. It runs an SQL statement that
appends several fields into the "tblOrder" table.

I then want to REFRESH the form and go to that newly
created record. I have tried Me.Refresh and still no
luck. Any ideas?
 
You must log in or register to reply here.

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

Refresh form and display new record 1
Access Form Refresh 1
Calculated fields on a form 2
Refreshing a Form 7
Refresh a form 3
I wish to assign Quantity the value of [Quantity]-[OrderAmt] 1
Copy selected records from two tables to two new tables 2
Duplicating records 3

Back
Top