use info from an existing record for a new record

use info from an existing record for a new record

Post by BURL ive » Mon, 14 Jan 2008 03:34:49

I believe this is possible and I am not asking to be spoon
fed.....could someone help........

I want to use the information in an existing record as the basis for a
new record.

thanks in advance.

use info from an existing record for a new record

Post by John W. Vi » Mon, 14 Jan 2008 04:31:37


which existing record?
How do you decide?
In what context: on a Form, in a query datasheet, in a table datasheet...?

The most common case (and easiest) would be in a Form, letting the user enter
a record and have some (or all) of the fields default to the value they
entered on the current record when they start the next record. To do so, put
code in each such control's AfterUpdate event:

Private Sub controlname_AfterUpdate()
Me.controlname.DefaultValue = """" & Me!controlname & """"
End Sub

John W. Vinson [MVP]


use info from an existing record for a new record

Post by BURL ive » Wed, 16 Jan 2008 20:55:48

On Sat, 12 Jan 2008 12:31:37 -0700, John W. Vinson

I am probably making too much of this due to my inexperience so please
bear with me.....

I have a table containing a primary key and a customer request

I have a table containing various tasks and comments
(tblAnalyt)...this table is related to tblLog through a foreign key (I
believe that is the term to use)

I have a table containing varous items and costs (tblComponents) and
uses the same foreign key to relate to tblLog

The initial request by a customer is logged into tblLog and the
related tasks and items associated with that request are entered into
the tables tblAnalyt and tblComponents

In some cases, a customer request may be very similar to one already
in the tblLog table (such as a revision to an existing request)
those cases, I would like to call up that related request and use its
data as the basis for the new entry instead of typing all the info in
again....I also would like to do this without VB if it is
possible....for some reason I thought the appropriate entry of a form
setting would allow me to this (such as opening the form in entry mode
and searching for the specific log entry).

Here is how I'd like it to work.....I'd like to create a form using
tbl as the basis and in it contain contain subforms using tblAnalyt
and tblComponents as the basis of the subforms.....the user enters the
known info on the form and all the related info on the subforms come
up....they would modify it and it would now be saved as a new entry.

I hope I was more clear this time.....

Is my request possible without VB? If not, then how would I do what I
want to do?