Method or data member not found (1 Viewer)

zackat

New member
Local time
Today, 10:30
Joined
Apr 18, 2006
Messages
8
Hi,

I have a Form with a subform.
I'm trying to do the following in the Form Load event.

me.frmOrderSubForm.Recordsource="Select * from tbl_Order"

which gives me the error: Method or data member not found.

I have set all the reference for DAO 3.6 and Access 11.0; but still having the error.

Also used a DAO check to ensure DAO is installed, which it is.

What am I missing here??
 

KenHigg

Registered User
Local time
Today, 05:30
Joined
Jun 9, 2004
Messages
13,327
Is this in the main form or sub form load event? Why not just bind it to the table?
 

zackat

New member
Local time
Today, 10:30
Joined
Apr 18, 2006
Messages
8
It's in the main form.
The sub form is a bound form on tbl_Order.
 

KenHigg

Registered User
Local time
Today, 05:30
Joined
Jun 9, 2004
Messages
13,327
I don't follow why you are doing this but this may help:

me.frmOrderSubForm.form.Recordsource="Select * from tbl_Order"

???
 

zackat

New member
Local time
Today, 10:30
Joined
Apr 18, 2006
Messages
8
It did the trick! Thanks!

Why I am using this: I used this is many other database projects and it worked fine.

I am using it to populate late a selection form ( the main form) in which selections can be made via comboboxes on the tbl_Order which will be displayed in the subform as result.
 

KenHigg

Registered User
Local time
Today, 05:30
Joined
Jun 9, 2004
Messages
13,327
Hum... I still think you could just bind the subform directly to the table then requery the subform when the combo boxes change... But if it works as it - Cool....
 

Users who are viewing this thread

Top Bottom