Object variable not set

[Harmough]

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.

[mmmsonu]

please refresh recordset object then run your program

[Harmough]

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.

[Glenn]

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

Set FlexMain.DataSource = RSMain

[Harmough]

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

Thanks anyway!