ENDING TO BEGINNING

[GOOSE]

HAVE A SIMPLE INVENTORY FORM. [BEGINNING INVENTORY],
[PURCHASES],[SALES],[ENDING INVENTORY], ETC... WHEN FORM
IS CLOSED, I WOULD LIKE TO TRANSFER VALUE FROM ENDING TO
BEGINNING. CAN I DO THIS WITHIN THE QUERY OR BUILD AN
EXPRESSION ON THE 'ON EXIT' OR WITHIN A MACRO AS THE FORM
CLOSES.
ANY HELP WOULD BE APPRECIATED
GOOSE

 

[John Vinson]

HAVE A SIMPLE INVENTORY FORM. [BEGINNING INVENTORY],
[PURCHASES],[SALES],[ENDING INVENTORY], ETC... WHEN FORM
IS CLOSED, I WOULD LIKE TO TRANSFER VALUE FROM ENDING TO
BEGINNING. CAN I DO THIS WITHIN THE QUERY OR BUILD AN
EXPRESSION ON THE 'ON EXIT' OR WITHIN A MACRO AS THE FORM
CLOSES.
ANY HELP WOULD BE APPRECIATED
GOOSE

Please DON'T SHOUT. All caps is hard to read and considered impolite.
Use all lower case if you have difficulty with the Shift key.

To do this you will need VBA code in the Form's BeforeUpdate event.
It's preferable NOT to store this information though; it's redundant,
since you can use a Query to find the previous [Ending Inventory]
amount at any time.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

-----Original Message-----

HAVE A SIMPLE INVENTORY FORM. [BEGINNING INVENTORY],
[PURCHASES],[SALES],[ENDING INVENTORY], ETC... WHEN FORM
IS CLOSED, I WOULD LIKE TO TRANSFER VALUE FROM ENDING TO
BEGINNING. CAN I DO THIS WITHIN THE QUERY OR BUILD AN
EXPRESSION ON THE 'ON EXIT' OR WITHIN A MACRO AS THE FORM
CLOSES.
ANY HELP WOULD BE APPRECIATED
GOOSE

Please DON'T SHOUT. All caps is hard to read and considered impolite.
Use all lower case if you have difficulty with the Shift key.

To do this you will need VBA code in the Form's BeforeUpdate event.
It's preferable NOT to store this information though; it's redundant,
since you can use a Query to find the previous [Ending Inventory]
amount at any time.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
.
thanks fo your help and sorry about the caps

could you please give me a little more detail