Search results

Thank you so much everyone for your inputs. I took Steve's advise and that resolve my issue. Happy Weekend!

The tab header disappear because I had the subform bigger than the main form, I've shorten the subform and the problem disappear.

Gasman, Here's the afterupdate codes behind the combo box that has the changes made from Collin. Quynh

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.

Wow amazing! Thank you so much.

Here's a cleaner mdb that I've deleted old codes and compiled.

there's no link fields I'm still pulling my head on this, two full days already :-( Experts please help me ...

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.

what does that mean?

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:

still pulling my hair out of this, is there someone available to help?

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...