How to link data in one form to another form?

[Jeffersuan]

Alright, so here is the problem:

I have several tables linked to specific forms to ease data entry. The
forms are made to be filled out one after another: Project Info ->
Client Info -> Governing Agency, etc. In each form there are fields
that will have the same data as the previous form(s). I want to be
able to enter all the data from scratch in the first form, and then for
each subsequent form, have the identical fields be filled with the data
from those fields. I tried using the expression =Forms![Project Info
Form]!ClientName for the field "ClientName" in form "Client Info" .
This worked, but only in the immediate context, because only the data I
entered by hand was saved to the corresponding table. Also, I couldn't
edit the auto filled fields. Is there a way I can achieve the same
result, but have the info saved to the appropriate table, and be able
to edit the information?

Thanks for any help!

Jeffersuan.

 

[james.igoe]

You might global variables. I have some procedures where I need to use
the same set of values in multiple, sequential stored procedures - same
idea different application - and can recall the global variables that I
need to use.

So once you fill the form, set the global variables from the form -
using the appropriate techniques to get values from list boxes, text
boxes, and combo boxes - then reuse and modify the variables as needed
in subsequent forms. Just remember that you need to reset the global
variables if they need to be reused.


Regards,

James Igoe

(e-mail address removed) || http://code.comparative-advantage.com

 

[Jeffersuan]

Global variables? I am not familiar with this technique. Further
explination would be much appreciated. Thanks again

Jeffersuan

 

[james.igoe]

similar to dim but as follows:

''used ofr passing viewing option as chart or wks to frmViewTabs
Global gstrViewTabType As String

often created in separate module of global variables. it has a life
beyond the module, and can be called from any form or module, so
longer-lasting than public variables. have to run, but try google.


James Igoe

(e-mail address removed) || http://code.comparative-advantage.com