Dynamically created RowSource not found

[GraeagleBill]

I have a simple popup form with a single combo control. The Open code determines the content of the rows setting the control's RowSource. When I click on the combo Access reports it can't find the "RecordSource" NOT the "RowSource" of the combo.

So, I set the popup's "RecordSource" innocuously to one of my tables but the error persists. I verified that the "RowSource" was correctly initialized, as viewed in the IW (Below).

Any ideas?

[GraeagleBill]

The error:

[Micron]

You must have accidentally set the record source for the control to be the same as your row source setting? What do you see when you click on the drop down in the property sheet for the control's recordsource?

[davegri]

I suspect that the form's recordsource property is being set in code. You can't tell by looking at the form in design view, since setting the recordsource in code doesn't "stick" in the design view.
Do a search for '.recordsource' to see if you can find it.

[GraeagleBill]

Good grief! When I went to the property sheet for the combo to check out your suspicion I noticed that the RowSource "type" was set to "table/query" rather than "Value list". That does make a big difference

Thanks for your thoughts,
Bill