Copy Information Between Forms

[alxj]

I have an ordering system which uses a form with 2 subforms for the order (Client / Order / Products Requires), after this order has been taken it is passed on to the stock control department. Due to the nature of the product it can be stored in many locations. The location ref number needs to be shown next to the product required (for all products ordered)and each product on the order can come from a different location.

I have created a stock location form which is a query of 2 tables with a subform based on 1. The Main shows the location details and includes a location ref number. This location ref number need to be inserted into the sales order page upon return. As this task is carried out hundreds of times a day just remebering and typing the number in could prove a problem.

I have not done anything like this before. I think that you could put code to the effect..
copy ref no in the on exit event of the allocation
and then
paste ref no in the on enter (or on click) event of the location ref box on the sales order.
Am I looking in the right direction?
Does anybody know how to apply this technique?

Thank you all in advance (sorry for the length of message)

Alex

 

[Jack Cowley]

Create a global variable and set it to the RefNo when you leave that form. In the next form use whatever event will work best to place the varible into the field on your form and then reset the variable to "".

 

[alxj]

i have used the global variable method as specified and it works great. The only problem is i can only get it to work when it is taking the value from the main form if i ask it to take it from a subform it does not work, is it possible to do this?