Steve,
Yeah I thought the same, I don't need the recordsource on the main form, but for some reasons when I removed it I don't see the tabs appear so I just left it there.
Yes it's the same.
I've attached the mdb.
Once open, select a value in the combo box on top, any value should have some records, but when you go to the Summary form, it doesn't display anything.
Thanks for your help.
cmbId is a text not number
ignore my MsgBox code, I was trying to say that my strSql_sum is correct it produce records but my subform frmSummary does not show any records :banghead::banghead:
Hi,
I'm a new Access VBA programmer and also a new member to this forum, hoping you can help me resolve a similar issue in this thread.
I have a main form (frmAll) that have a combo box where I select a value and I want the subform (frmSummary) to display the recordset that meet the criteria...