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

Object Does Not Support this Property or Method

P: 2
I have a similar question to the OP. I currently have a form "bills" that has two subforms billsupper and billslower. When the main form loads the upper subform is visible and the lower one is not. When you double click on the one of the records on billsupper i then make billslower visible and then try to update the record source based on which one was clicked but i get the same object error.
Expand|Select|Wrap|Line Numbers
  1. Private Sub BillShtName_DblClick
  2. Forms!frmBills!sfmBillsLower.Visible = True
  3.  
  4. strBillType = Me.BillType
  5.  
  6. Forms!frmBills!sfmBillsLower.RecordSource = "SELECT BillsFormLower.* FROM BillsFormLower WHERE (((BillsFormLower.BillType)='" & strBillType & "'));"
  7. end sub
Feb 21 '09 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,409
Scuba,

Welcome to Bytes!

I have moved your post to it's own thread as it's not a part of the previous one (as that is fully answered, and you don't have a solution, it can't be).

To move forward, I think it may help to know which line the error occurred on. I have assumed from the limited information in your post that the error message text is is the same as I've used for the subject of the thread. If this is not the case then please post that too.

I did have a scan over the code first but didn't see anything that would obviously cause that error by the way.
Feb 21 '09 #2

DonRayner
Expert 100+
P: 489
At first glance is looks like line 6 should be changed to this. Notice I added .Form before the .RecordSource

Expand|Select|Wrap|Line Numbers
  1. Forms!frmBills!sfmBillsLower.Form.RecordSource = "SELECT BillsFormLower.* FROM BillsFormLower WHERE (((BillsFormLower.BillType)='" & strBillType & "'));"
Feb 21 '09 #3

P: 2
This worked! Thanks so much for your help
Feb 23 '09 #4

NeoPa
Expert Mod 15k+
P: 31,409
Referring to Items on a Sub-Form may be helpful then.
Feb 23 '09 #5

DonRayner
Expert 100+
P: 489
@scubahood
You're welcome, glad I could help. Please do take the time to check out the link that NeoPa supplied.
Feb 23 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.