use an existing record as basis for new record

[MrGQ via AccessMonster.com]

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

I have a database of quotes that I issue....

I have a table containing a primary key and a customer request
(tblLog)..the fields here are the primary key, a quote number, a revision
number, an addendum number and the basic request from the customer.....

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 revised. The revised request is
very similar to one already
in the tblLog table (such as a revision to an existing request)...in
those cases, I would like to call up that related request (from the original
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 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
tblLog as the primary form and in it contain contain subforms using tblAnalyt
and tblComponents as the basis of the subforms.....the user enters the
known info on the primary form (such as quote number) 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 clear.....

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