goto last record in subform 
Author Message
 goto last record in subform

I have a form with a subform.  On the form someone chooses an item from a
listbox and it populates a record in the subform (on the doubleclick event).
After it populates I want it to go to the last record in the subform (thus
the one they just entered) so they can make any changes.  I'm trying to use
the simple docmd.GoTo but it gives me the error that the subform is not
open.  How do I get it to work? Thanks!


Tue, 30 Nov 2004 07:22:29 GMT  
 goto last record in subform
nevermind - I figured out that I first had to go to the control.


Quote:
> I have a form with a subform.  On the form someone chooses an item from a
> listbox and it populates a record in the subform (on the doubleclick
event).
> After it populates I want it to go to the last record in the subform (thus
> the one they just entered) so they can make any changes.  I'm trying to
use
> the simple docmd.GoTo but it gives me the error that the subform is not
> open.  How do I get it to work? Thanks!



Tue, 30 Nov 2004 07:29:48 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Subform refresh moves last record to top of subform

2. GOTO a spedific record in a subform

3. Copy Form records and Subform records....

4. Help: retrieve LAST record on database of 50.000 record

5. GOTO A RECORD

6. Newbie: Goto Next/New Record in VBA

7. Goto specific Record in a Table using VB

8. GoTo Record

9. Records in a subform

10. Not save new record when enter subform

11. HOW DO I GROUP AND SUM CERTAIN RECORDS IN A SUBFORM

12. Synchronising form/subform current record

 

 
Powered by phpBB® Forum Software