Temporary table as subform's record set

[Overtime]

Hello,


I need to use a temporary table as recordsource for some of the controls in my subform. I tried to get the main form to create the temp table (run create table SQL OnOpen) but I keep getting an error saying that the recordsource (for the subform) does not exists, then when the form opens, the subform is not displayed. The temporary table gets created successfully, but it appears that access checks for the subform's recordsource before the OnOpen or OnLoad events are fired, and obviously, the temp table will not be found. Does anyone know a way around this?

thanks a lot

 

[spikepl]

Remove RecordSource from subform. Set the subform's RecordSource in the form's (not subform's) OnOpen or OnLOad and requery the subform

 

[Overtime]

Coming to my rescue again, thank you so much