×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SourceObject

SourceObject

SourceObject

(OP)
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!!!!!!

RE: SourceObject

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

RE: SourceObject

(OP)
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!!!

RE: SourceObject

(OP)
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!!
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close