Can I do this - Unbound subform query driven

[fileman1]

I have a main form, onto which I dragged a subform. The subform is unbound, and is a continuous form.
The main form generates a query which I want to be the recordsource of the subform. Does not seem to work.

I was trying:

Forms![Copy of Mainform]!MainSubform.Form.RecordSource = MySql

[Forms]![Copy of Mainform]![MainSubform].Form.Requery

 

[dhookom]

MySql has no value that we can see. You should not need to do a requery after updating a subform's record source.

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

FYI, an unbound form has NO RecordSource (AFAIK)

 

[fileman1]

Thanks Duane, my second line was to try and kick it into life.
Thanks PHV. I just tried a recordsource of a table, that woke up. So maybe I can fill a dummy table. I do not want to add or amend data, it's just a search reference form.

 

[dhookom]

You still haven't provided any information about "MySql". Have you confirmed it returns records with no errors?

Duane
Hook'D on Access
MS Access MVP

 

[fileman1]

Thanks, yes, it currently fills a list box okay without any errors. I am going down the road of inserting into a table thinking that was my easy option.