Display Last Record

E

ESERSEN

I have been searching posts for 3 hours trying to find a way to display
the last record in a sub form on a tab-controlled page. I have tried
many 'suggestions' that appeared to have worked for others but will not
work for me. Can someone please help? I have a main form 'MyMain'
and a sub form 'MySub'. The sub form is located on a tab-controlled
page. When I select a main record, I want to be able to click on the
tab and see the subform display the last record. I have tried
DoCmd.GoToRecord, , acLast. This does not work. I have tried
..bookmarks and could not get that to work. Can someone PLEASE work
with me to get this to work? It can't be that hard.

Thanks :)
 
K

kingston via AccessMonster.com

Try this:
Me.MySub.Requery 'if you need this
Me.MySub.Form.Recordset.MoveLast
 

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

Need combo box to refresh when moving to new record 2017 1
Inconsistent Add Record Performance 1
Multiple subforms 0
Controlling a Sub Form 4
how to goto last record, add new record 14
postion subform to last record after adding 2
Locate record in a subform 1
GoToRecord 4

Top