Ummm...
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]
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
(tblLog)..
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)...in
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?