Hello,
I have created a spread-sheet to invoice my clients.
Variables in the spread-sheets are Invoice Date, Invoice Number, Client Name and their billing address.
I want to create a Command Buttion named 'Create New Invoice'. Clicking this CmdButton, will clear the spread-sheet, populate Invoice date (date is last day of the current week, SUNDAY) and increment Invoice Number by 1. When I choose my client ID (from the Drop down list), it should display Client Name and their billing address.
Please advice how can I do this?
Your Help will be greately appriciated.
I have created a spread-sheet to invoice my clients.
Variables in the spread-sheets are Invoice Date, Invoice Number, Client Name and their billing address.
I want to create a Command Buttion named 'Create New Invoice'. Clicking this CmdButton, will clear the spread-sheet, populate Invoice date (date is last day of the current week, SUNDAY) and increment Invoice Number by 1. When I choose my client ID (from the Drop down list), it should display Client Name and their billing address.
Please advice how can I do this?
Your Help will be greately appriciated.
