Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SourceObject

Status
Not open for further replies.

funkytunaa

Technical User
Oct 9, 2005
116
AU
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!!!!!!
 
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
 
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!!!
 
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!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top