Opening a subform in add mode

[kfoxNevada]

I want to open a form (for a facility) in edit, but open the subform ready to add a new record. I wanted to turn off the 'Record Navigation' on the subform, so that the user cannot look at other records for that facility, without going through another access point.

Any ideas? Thanks.

 

[docmeizie]

Yeah. Pretty simple if you actually think about it. You can set the add mode data on each form if you open the form independently in design view. Just go to the Data tab on the properties box for the form (the little black box that appears in the upper left hand corner of the form). Go down to the data entry line and turn that to "Yes". That should allow just that form to be opened up in data entry mode where it opens up to a blank form (subform in your case).

For turning off record navigation just go to the Format tab on the same properties box go to Record Selectors and Navigation Buttons and turn those to "No". Case closed and saved reopen your main form and watch the beauty unfold as you are now able to just add records to the subform and have the confusing record selector arrow gone and no navigation buttons to confuse with the other buttons on the main form!!!!

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmm

 

[kfoxNevada]

I didn't know that "DataEntry = True" mean't add mode. That's kinda goofy. They should have called that feature "AddNewRecord" or something. Thanks! I've spent hours on this!

 

[docmeizie]

No problem. Yeah that would be the "easy" way *doing the quote fingers like Dr. Evil* of doing things, but alas they have to put it in a way that can confuse and confound some.

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmm