Hi everybody, I'm stuck at this issue..
I got no idea how to load query on new form base on my selection from other form.
Currently I got this "Select Officer" screen/form asking user to select which officer you want to review their report on customer account. Example; each officer got 10 customer account and when I select the officer name from dropdownlist then click on button "Review by officer" the program will open "Review Report" screen/form while loading the query/data related base on earlier officer name from "Select Officer" screen/form.
I only know how to open screen/form with command button but I don't know how to make the next screen/form load query/data base on my selection from different screen/form.
I got no idea how to load query on new form base on my selection from other form.
Currently I got this "Select Officer" screen/form asking user to select which officer you want to review their report on customer account. Example; each officer got 10 customer account and when I select the officer name from dropdownlist then click on button "Review by officer" the program will open "Review Report" screen/form while loading the query/data related base on earlier officer name from "Select Officer" screen/form.
I only know how to open screen/form with command button but I don't know how to make the next screen/form load query/data base on my selection from different screen/form.