princeofdumph
Registered User.
- Local time
- Yesterday, 20:15
- Joined
- Mar 21, 2009
- Messages
- 12
hi, i want to build a vendor payments selection form using only queries and macros at the most i.e. no VBA code. i want to be able to do the following steps with that form.
" I select a supplier name from a drop down menu. i press go button.
immediately a list of due invoices is generated in the same form with tick/untick option.
in the form footer, a total of that suppliers' invoices is shown, total of invoices ticked for payment, and total gross payments selected so far.
In the end, a preview button to preview the resulting report before printing it. "
I hv tried building various queries and linking them but to no avail. plz help me with this as it will speed up my office work far better.
Thanx
" I select a supplier name from a drop down menu. i press go button.
immediately a list of due invoices is generated in the same form with tick/untick option.
in the form footer, a total of that suppliers' invoices is shown, total of invoices ticked for payment, and total gross payments selected so far.
In the end, a preview button to preview the resulting report before printing it. "
I hv tried building various queries and linking them but to no avail. plz help me with this as it will speed up my office work far better.
Thanx
