By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,231 Members | 1,613 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,231 IT Pros & Developers. It's quick & easy.

Subform sourceobject

P: n/a
Hello,

I have just changed some functionality in a form which has totally
screwed up the subform.

form: subfrmLoadsheets
subform: subfrmLoadsheetsEquipment (Child/Master - TransactionID)

The problem occured when I changed some code to disable the subfrm
until the required number of fields on the master form have been
filled in. Basically the subform source object is set to a blank form
by default.

When the criteria has been met the following code is triggered:
Me.subfrmLoadsheetsEquipment.SourceObject =
"subfrmLoadsheetsISTEquipment"

This works but the subform displays all records (it ignores the
TransactionID)
This problem does not occur if the subform's sourceobject is set
before the main form loads.

I have tries adding codes to update the master/child fields, requery
the subform to no avail.

Please help.... I am stuck.

Regards,

Nathan
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
> I have just changed some functionality in a form which has totally
screwed up the subform.

form: subfrmLoadsheets
subform: subfrmLoadsheetsEquipment (Child/Master - TransactionID)

The problem occured when I changed some code to disable the subfrm
until the required number of fields on the master form have been
filled in. Basically the subform source object is set to a blank form
by default.

When the criteria has been met the following code is triggered:
Me.subfrmLoadsheetsEquipment.SourceObject =
"subfrmLoadsheetsISTEquipment"

This works but the subform displays all records (it ignores the
TransactionID)
This problem does not occur if the subform's sourceobject is set
before the main form loads.

I have tries adding codes to update the master/child fields, requery
the subform to no avail.


Setting the LinkChildFields and LinkMasterFields properties after setting the
subform control's SourceObject property has always worked for me, but if you
can't get that to work, try, instead, setting the Locked or Enabled properties
of the subform *control* using the same logic.

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)
NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<
Nov 12 '05 #2

P: n/a
Thanks Bruce,

I have fixed the problem - human error. DOH!

Thanks for the help anyway.

Regards,

Nathan
Nov 12 '05 #3

P: n/a
> Thanks Bruce,

I have fixed the problem - human error. DOH!

Thanks for the help anyway.


You're welcome. Hey, if it weren't human error, it would be "by design",
wouldn't it? <chuckle>

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)
NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.