Method or data member not found

[zackat]

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]

Is this in the main form or sub form load event? Why not just bind it to the table?

 

[zackat]

It's in the main form.
The sub form is a bound form on tbl_Order.

 

[KenHigg]

I don't follow why you are doing this but this may help:

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

???

 

[zackat]

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]

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....

 

[zackat]

True, you are right!