Form not working correctly -- Help!!

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

In Access2000 (frontend) Sql server (backend)

I have a form which has a JobNumber, a DueDate field, and a command button
which takes
the user to a sub-form which allows the user to change the date by a certain
number of days, enter a reason why the date is being changed, etc. Once the
fields have been filled in, the user exits the subform and returns to the
main form called JobTracking. I wrote code on the close event that closes
and opens the main form in order that the DueDate updates with the changes
made in the sub-form. The issue that I am having, is that when the sub-form
closes and re-opens the main form, it does not open to the JobNumber that I
just updated. The user has to use the find feature or scroll to the record
that was updated.

Can you offer suggestions on how I can go to the record I just updated upon
closing the sub-form?

Thanks in advance.
 
-----Original Message-----
In Access2000 (frontend) Sql server (backend)

I have a form which has a JobNumber, a DueDate field, and a command button
which takes
the user to a sub-form which allows the user to change the date by a certain
number of days, enter a reason why the date is being changed, etc. Once the
fields have been filled in, the user exits the subform and returns to the
main form called JobTracking. I wrote code on the close event that closes
and opens the main form in order that the DueDate updates with the changes
made in the sub-form. The issue that I am having, is that when the sub-form
closes and re-opens the main form, it does not open to the JobNumber that I
just updated. The user has to use the find feature or scroll to the record
that was updated.

Can you offer suggestions on how I can go to the record I just updated upon
closing the sub-form?

Thanks in advance.


.
Try form_frmMainForm.Requery after you close the pop-up
Click to expand...
form rather than close and open the main form.
 
Sounds like you are closing the first form when you go to the next
form. Don't bother closing the first form, just open the next one.
When you then close that second form the first one will still be at
the same record.

Russ
 
Back
Top