View Single Post
Old February 16th, 2005, 07:44 PM
dlamarche dlamarche is offline
Authorized User
Join Date: Feb 2005
Location: Frankston South, Victoria, Australia.
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default Creating a new record in a subform

Hi. I ran into a weird difficulty the other day. I was trying to open a form from another form and move to the new record IN THE SUBFORM! I was never able to do it!

I've been programming forms for a few years with VBA but I never encountered this one! I am opening the form from a command button in another form and it is supposed to move to the new record in the subform right away but (and it makes sense) it moves to the new record in the main form. When I try to refer to the subform after the OpenForm method I am always told that the form is not open thus I cannot move to the new record.

I solved my problem by making the subform's DataEntry property to True but I loose sight of the other records in the subform.

Any ideas anyone???