Update the subform with query results in a main form

[williamc3502]

Hello everyone, I am new in ms access and want to ask for helps.

I created a main form containing list boxes and a subform. What I want to do is to select items in the list boxes. Then, by clicking "Search" button, the data filtered by the selected items will be shown in the subform. But the subform cannot work and show the query results. I think I miss some VBA codes. Can anyone help me to take a look of my database? Thanks a lot!



Complaint Database_William.zip

[jzwp11]

It looks like your code is not at fault. The problem lies in your form. You have the main form bound to the complaint table; it should be unbound. Secondly and most important to your issue, is that you had the subform linked to the main form via to the refnum field. Having this prevented the subform displaying data because their was no bound refnum control on the main form so the subform could not join to it. To solve the issue, I removed the complaint table from the main form's record source, and I removed the refnum join between the main and subform. The corrected DB is attached; the subform is showing records. You will have to verify whether it is showing the correct records.