Moving Data from Form to Form

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

James

I get an object required error when I open the form. I
have opened it with the code and everything and I have
told the form that once the form has opened and excecuted
the code it will then make my first for invisible but it
is still open...

What is the "object" that it is refreing to? Do you have
any ideas?

Many Thanks

James

P.S. If it is easier to have a look at the database that
would be fine as there is no data in it at the moment just
some random stuff...
-----Original Message-----
Note sure of the context of HOW this 2nd form is opened. However, my example
will only work for adding one record. I.e.: open that 2nd form, add the
record, and then close the form.

I suppose if you need the ability to move around, and add more then one
record at a time (I don't like that kind of UI, but you certainly could try
moving the code to the on-insert event

You thus would get:

me!RefNum = forms!FormFirst!RefNum


The above one line of code should do the trick. Of course, this does mean
that the 2nd form will always assume the first form is
Click to expand...
opened...
 
I have the following code:

me!RefNum = forms!FormFirst!RefNum

I have been told to place this in the On Insert and I have
a before Insert and After Insert no On Insert where could
I find this?

Many Thanks

James
 
Back
Top