Fill up several fields from a form to another form in Microsoft ACCESS

[Gouri Dutta]

I have a task of filling up several fields from a current form (if a condition is true) to another form (or a table) by creating a new record in the second form (or the second table). Do not have much clue.
Any help would be appreciated.

 

[spikepl]

The first question, which anyone from here probably will ask, is why are you copying existing data? A query can pick up data from one or more tables, and present them for processing exactly like data in a table. And in this way you do not have duplicates of data.

Update: I have misread your posting. So you wish to put data from one form on another form? If both are open then the way of referring to controls on a form different from the one on which you are are described here:

http://access.mvps.org/access/forms/frm0031.htm

 

[Gouri Dutta]

Thanks, spikepl!But the problem was an action be taken to fill up a few fields in a second table ( or form not subform) in order to start the processes in the second form. still do not know.

 

[boblarson]

Can you give an example of the data that you are wanting in the second table that would be in the controls on the form? Are those controls bound to any fields in another table or are they unbound and just hand entries?

 

[Gouri Dutta]

All are bound. The first table (potential Grant) has Potential Grant ID (primary key), CFDA_number, OPPortunity Number, Title of Grant, Application. If application='Y' then all these fields need to be populated in the second table(application); Potential Grant ID (Foreign key to second table). I forgot how to write appropriate codes for this insertion of fields in ACCESS. that is all I need. Thank you.

Gouri

 

[boblarson]

I think the design isn't optimally normalized but just create an append query and use the ID from the record on the form (using the form reference like

[Forms]![YourFormNameHere]![YourIDFieldNameHere]

as your criteria for the append query).

 

[Gouri Dutta]

Thank you! This was helpful.

But, I did not explain the whole problem very well. What I needed was a .AddNew Record, as this process will continue for some records in the first form to the second table (or form). My problem has been resolved.

Gouri