Object variable not set

I've opened a MS Access database by using this code:

Set DBMain = OpenDatabase(App.Path & "\Main.mdb")
Set RSMain = DBMain.OpenRecordset("Select * From MAIN")

Now I want to display the database information into a flexgrid control. But when I add this line:

Set FlexMain.DataSource = DBMain

it comes with the error message "Object variable or With block variable not set".

What am I doing wrong?

Thanks in advance.

please refresh recordset object then run your program

When using a data control, refreshing the recordset object would work, but now I can't seem to get it right. The only refresh method I could find is

DBMain.Recordsets.Refresh

but this gave the same error message.

Anyway, thanks for your reply.

I think you need to set the datasource property equal to the recordset RSMAIN

Set FlexMain.DataSource = RSMain

Nope, that didn't work either; the same result.

Thanks anyway!