Hi All,
I have a combo that list the customers and id. I have a button that runs a click event/macro which opens a report based on a function. I gave the parameters in the function and input parameters in the report it all works good.
A small twist is now, i want to be able to select the customer in the combo, click on the button and the record pertaining to that customer should get appended to the customer record. I have set the Customer id to autoincrement. That will assign and new customerid.
In short i want to copy the existing record as another record based on the selection in the combo.
Can any one advise.
Dwight
I have a combo that list the customers and id. I have a button that runs a click event/macro which opens a report based on a function. I gave the parameters in the function and input parameters in the report it all works good.
A small twist is now, i want to be able to select the customer in the combo, click on the button and the record pertaining to that customer should get appended to the customer record. I have set the Customer id to autoincrement. That will assign and new customerid.
In short i want to copy the existing record as another record based on the selection in the combo.
Can any one advise.
Dwight