Moves to new record

[Dave]

I have a child subform with three fields and a "Next" button. If I
populate these fields then tab out of the subform, the fields go blank
as though moving to a new record for input. However, I would like these
fields to remain showing unless I press the "Next" command button. What
can I do? Any help is appreciated.

Thanks all,

Dave B

 

[missinglinq via AccessMonster.com]

This is aircode, but I'd try opening the from used as the subform in Design
View, goto Properties and set AllowAdditions to NO. Next goto the Onclick sub
for your "Next" button and put Me.AllowAdditions = Yes before your code to go
to a new record. Then in the appropriate place set Me.AllowAdditions = No
again.

 

[John Vinson]

I have a child subform with three fields and a "Next" button. If I
populate these fields then tab out of the subform, the fields go blank
as though moving to a new record for input. However, I would like these
fields to remain showing unless I press the "Next" command button. What
can I do? Any help is appreciated.

Thanks all,

Dave B

If you open the form you're using as a subform and set its Cycle
property to "same record", you'll just tab back to the first control.

John W. Vinson[MVP]