How to go to record in subform?

[ittechguy]

I have a form which is used to either add a new customer, or search through customers. If adding a new customer, currently the user fills out the required boxes and hits submit, then as long as all required boxes are filled in (I have if statements to ensure this), the record is added. Currently the user doesn't get any proof that the record has been added. I could have a msgBox popup, but I think that'd be annoying.



Rather, I would like if the subform remained unfiltered but the it went to the record which was added. That is, that record would be selected and in view. Like, if it was near the bottom of the subform, you wouldn't have to scroll down to see it. How can this be done?

[June7]

Review https://www.accessforums.net/program...lue-51977.html

If the subform records are not sorted then the new record will probably be at the end and could probably use MoveLast method.

Bing: Access vba subform movelast
https://bytes.com/topic/access/answe...record-subform

[ittechguy]

The subform records are not sorted. They are not even linked to the main form (which idk, technically its not even a subform then?). The purpose of the subform is for users to see all of the customers. It can then be filtered using the form in the footer. If a user types in or selects a value in one of the combo box, the subform is automatically filtered.

I am going to give MoveLast a try. Thx!

[ittechguy]

Movelast method worked perfectly! Thanks.