Send data from one form to another

[mattc66 via AccessMonster.com]

Hi All,

I want to know if it,s possible to send data from 1 form to another totally
unrelated form.

The situation I have it one form is my MRP requirments. I want to open
another form PURCHASE ORDER (PO). I was wanting to add a button to the MRP
form that would send the data to the PO form. The MRP form may change to
multiple items and then add these different items to the same PO.

Does anyone have any suggestions on how I could do this or if it can even be
done.

 

[John W. Vinson]

Hi All,

I want to know if it,s possible to send data from 1 form to another totally
unrelated form.

The situation I have it one form is my MRP requirments. I want to open
another form PURCHASE ORDER (PO). I was wanting to add a button to the MRP
form that would send the data to the PO form. The MRP form may change to
multiple items and then add these different items to the same PO.

Does anyone have any suggestions on how I could do this or if it can even be
done.

STOP.

You are perhaps making a very common mistake - assuming that Forms are the
core of an Access database, and that they contain data. Neither is true.

The data in your database is stored in Tables, and only in Tables. A Form is
just a window, a tool that allows you access to the data in tables for
editing, viewing, data entry, etc.

What are the Recordsources of these two tables?

Is there data being added via the MRP form (whatever that might be, that's a
tla that I don't know) actually part of a PO? Are you storing "the same" data
in multiple different tables? If so, is that storage in fact redundant, or is
it legitimately being stored in two separate copies, either of which can be
edited independently of the other?

John W. Vinson [MVP]

 

[mattc66 via AccessMonster.com]

Hi John,

I am aware that behind every from is an underlying table.

MRP = Material Requirement Planning. This data comes from an external source
that is updated daily. So the table data is temporary.

The PO Table would be static and linked to a Supplier. It would have QTY,
Part, Due Date, Price and etc.

So I have a form that displays the MRP suggested Order Qty for the Part and
the recommended Due Date. My plan was to allow the user to click a button on
the form next to the item to add it to an Active Purchase Order form. (PO
Table).

What I want to know is can this be done?

Matt

Hi All,

[quoted text clipped - 8 lines]

Does anyone have any suggestions on how I could do this or if it can even be
done.

STOP.

You are perhaps making a very common mistake - assuming that Forms are the
core of an Access database, and that they contain data. Neither is true.

The data in your database is stored in Tables, and only in Tables. A Form is
just a window, a tool that allows you access to the data in tables for
editing, viewing, data entry, etc.

What are the Recordsources of these two tables?

Is there data being added via the MRP form (whatever that might be, that's a
tla that I don't know) actually part of a PO? Are you storing "the same" data
in multiple different tables? If so, is that storage in fact redundant, or is
it legitimately being stored in two separate copies, either of which can be
edited independently of the other?

John W. Vinson [MVP]