go to last form (continous form view)

[rockdc1981]

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,(subfo rm shows continous forms)

tnx

[pks00]

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.<<nameofmysu bform>>.SetFocu s
DoCmd.GotoRecor d , , acLast

[JConsulting]

private sub mycombo_AfterUp ddate()
Me.mysubform.fo rm.SetFocus
DoCmd.GotoRecor d , , acNewRec ' for new record
end sub

DoCmd.GotoRecor d , , acLast ' for last record