By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 1,486 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

go to last form (continous form view)

P: 51
i have a form and subform...
i have combo box on main form that has combo box to filter a record to be shown on subform...

the case now is ,

is it possible the on load or after select a record from my combo box, the cursor should be on the last or new record or should i say "last form" of my subform contents,(subform shows continous forms)

tnx
May 4 '07 #1
Share this Question
Share on Google+
2 Replies


pks00
Expert 100+
P: 280
Do you mean you want to go to the last record displayed in the subform?

You could try this from the mainform - use the afterupdate event of your combobox to do this as u want this to happen when u make a change

Me.<<nameofmysubform>>.SetFocus
DoCmd.GotoRecord , , acLast
May 4 '07 #2

JConsulting
Expert 100+
P: 603
private sub mycombo_AfterUpddate()
Me.mysubform.form.SetFocus
DoCmd.GotoRecord , , acNewRec ' for new record
end sub

DoCmd.GotoRecord , , acLast ' for last record
May 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.