record position lost when subform is closed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a command button on a form to open a new form against another table
to add detail records. When the 'sub' form is closed, the main form goes back
to the first record. Is there a way to keep the main form on the original
record?
 
Hi Mike,

Unless you are doing a requery the first form should stay on the same
record. If you are doing a requery, you can always cache the value of the
primary key of the current record before the requery then following the
requery, use the cached value to relocate that record.
 
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

First Subform record gets modified when closing form 3
Subform with no records 8
Saving a record in subform 5
Trouble associating parent form record to subform's record 1
filtering a form based on the values of a subform 0
Pop-up form that creates record that links 1:1 to main form 0
Filter on Subform Not Displaying as Expected 1
Cannot add records to subform 2

Back
Top