Hi guys,
I am really newby in access. I want to make filter based form, means we select value from the dropdown list, and sub report gets updated with that selected value.
What i did:
Created main form
Created dropdowl list
Created button
Created subform
Now, how can I update subform's data with selected value from dropdownlist?
I tried to put and event on button, and put
eTemplate_subfo rm1.SourceObjec t = "select * from LAudience"
eTemplate_subfo rm1.Requery
but, seems like this code is not executing. How can i debug in access?
ur help will be appreciated.
I am really newby in access. I want to make filter based form, means we select value from the dropdown list, and sub report gets updated with that selected value.
What i did:
Created main form
Created dropdowl list
Created button
Created subform
Now, how can I update subform's data with selected value from dropdownlist?
I tried to put and event on button, and put
eTemplate_subfo rm1.SourceObjec t = "select * from LAudience"
eTemplate_subfo rm1.Requery
but, seems like this code is not executing. How can i debug in access?
ur help will be appreciated.
Comment