Creating a new record with data from another table

[sarora529]

I want to create a form that allows me to pull in data from one table and insert it into another. The table that I would be pulling data from would be like a template/typical data and then it would inserted into the other table where it can be modified. This is to cut down on the time spent entering data because most of the information stays the same except a new record needs to be created everyday.

 

[Crowley16]

one solution would be to have the form be bounded to a new record in the destination table, but in the onOpen event (or somewhere else) of the form, "retrieve" the relevant details from the origin table for that particular record

--------------------
Procrastinate Now!

 

[sarora529]

Ya that is exactly what I want to do but have no clue how to go about it. Do you know of any references that would help me write the code for that because I doubt the access wizard does that.

 

[Crowley16]

well, firstly, create a bound form for the destination table.

then in the control where you want to pull the records across, right click, select build event.

select the relevant event, and in there just use a recordset to retrieve the record, and the set the fields to the values in the recordset.

--------------------
Procrastinate Now!

 

[traingamer]

Or you could just set the default values in the main form and skip the rest of it.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill