RE: Next record on parent form after update of child form

The code that you are using to move to the next record, you mantion that you
are setting the focus to the main form. instead set the focus to a field in
the main form and then move to the next record

Forms![MainFormName]![FieldName].SetFocus
DoCmd.GoToRecord , , acNext

--
In God We Trust - Everything Else We Test


"Bill" wrote:

> I posted a similar message yesterday but don't think I posed the question
> properly.
>
> After adding/editing a record to a sub/sub form I'd like to move to the next
> record of the main form by using the on click event of a button on the
> sub/sub. I've tried to set focus and move control to the main form from the
> sub then goto next record but either those are not the appropriate tools or
> my syntax is bad.
>
> Are there special considerations when moving back from sub to main.
>
> What I'm trying to accomplish can be done by clicking on the next record
> button of the main form but one would think it would be easy to do
> programatically.
>
> I'd think this would be a fairly common funtion for anyone inputing data
> into a subform.
>
> Bill
.