Moving data from form to form (Complete)

[James]

Hello How can I move data from one box and let the code

programatically input the information in the ref box to
another form? In other words lets say I do the following:

I put in on my first for the ref no as 12345

Then on the following for I would like the ref no to
automatically be pulled from the previous form and added
into the table and then start a new record with that
refrence number?

Is there a way I can do this?

Many Thanks

James

 

[Albert D. Kallal]

In the 2nd forms on-load event, you can simply go:

if me.newrecord = True then
if isnull(me!RefNum) = True then
me!RefNum = forms!FormFirst!RefNum
end if
end if

 

[James]

For some reason this is not working it just sits and does
nothing when you ask it to.

Its strange I can see what teh code is supoosed to do but
it is just not doing it for one reason or another.

Any Other Suggestions?

Would you like to see the database?

Many Thanks

James