Hi, I have written a database which mainly uses macros rather than VBA (sorry - I know this is not good - but everything has worked fine up til now!). I am trying to add a function but am stuck.
On my database I have a main form to show each customer. Within this form is a subform (joined by CustNo) showing the bookings the customer has made.
I am trying to write a procedure (and I am really not good at vba!!) so that, when a button is pressed in the invoices subform, the particular invoice is printed (I can do this bit!) THEN a series of queries are run to update certain information for that invoice (identified by a unique Transaction Number).
My natural reaction is to link the button to a macro that runs a series of events but I am not sure how I identify the unique Transaction Number in the various events.
Please help - it is probably really simple - but I can't work it out!
Thanks
On my database I have a main form to show each customer. Within this form is a subform (joined by CustNo) showing the bookings the customer has made.
I am trying to write a procedure (and I am really not good at vba!!) so that, when a button is pressed in the invoices subform, the particular invoice is printed (I can do this bit!) THEN a series of queries are run to update certain information for that invoice (identified by a unique Transaction Number).
My natural reaction is to link the button to a macro that runs a series of events but I am not sure how I identify the unique Transaction Number in the various events.
Please help - it is probably really simple - but I can't work it out!
Thanks
