subform, click a button and goto control of last record

[mchadwick]

I have a subform in a form linked together by a LANID, on averge there are 5 records in the subform that are connected to the Form. So, I want to add a new record in the subform for this LANID (we'll say it is "domain\bjones"). I want to put a button on the form footer and when clicked go to the last record of "domain\bjones" (the record currently open) records or information and modify the record (which is a new record). WHat I have tried to do so far is to put a macro on the button and do a goto record and it says the form is closed. I do have it (subform) open in the form.

[burrina]

Try this:

DoCmd.GoToRecord , , acLast

HTH

[June7]

Which form footer?

If the button is on the main form, then must first set focus to the subform container control. I always name container different from the object it holds, like ctrDetail.

Me.ctrDetail.SetFocus
DoCmd.GoToRecord , , acNewRec