Transfer certain data to another form

[Tony]

When I finished working on a certain data, I would like to move from working
file (form) to Process File (form). I thought I can establish a button with
inserted Macro... a push of a button then it would move a data/file. Would it
be possible?

 

[Arvin Meyer [MVP]]

When I finished working on a certain data, I would like to move from
working
file (form) to Process File (form). I thought I can establish a button
with
inserted Macro... a push of a button then it would move a data/file. Would
it
be possible?

Data is not stored in forms, it's stored in Tables. It would be possible to
use 2 tables, but generally, not a good idea unless there's much more data
in the second table. Even then, you normally only move the key to the second
table. If it is a simple change in status, it's better to add a yes/no field
to the first table to show the data in Process.

 

[bhicks11 via AccessMonster.com]

Yes Tony,

Leave the file form open and in the OnCurrent event of the Process form, set
each controls value to the control on the file form. Like:

me.thiscontrol = forms!fileform.control1

etc.