SourceObject

[funkytunaa]

Trying to change a subform by using "sourceobject"

Button works but the "subform2" is changed into datasheet view. I have changed the form so it says "no" to datasheet view, but still shows wrong.

Should mention this is an upgrade from an mdb database and all was working ok with the old one?

Ideas?


Cheers!!!!!!

 

[PaulBricker]

Try going into the property sheet for the subforms form object (click the square box in the upper left hand corner of your subform until the little black square shows). Look at the Default View property. The default setting for this property is datasheet. You can change it in there to single form, continuous form, etc.

Paul

 

[funkytunaa]

I wish it were that simple, I've checked the "default view" and I have changed the "Allow datasheet view" to no on all 3 sheets.

Main
Sub1
Sub2

If I open the form seperately, rather than in the sourceobject, it opens fine.

Cheers!!!

 

[funkytunaa]

I inserted a nested subform in the subform on the main form as I needed to put in multiple addresses and now it works fine.

Stupid head microsoft.

Cheers!!