Moving data from form to form (Complete)

  • Thread starter Thread starter James
  • Start date Start date
J

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?
Click to expand...

Many Thanks

James
 
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
 
Thanks for that so that will actually put the refrence
number into the table for me?

Many Thanks

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
 
Back
Top