Copying one text value to another

  • Thread starter Thread starter Merwin12
  • Start date Start date
M

Merwin12

I have two text fields in a form.
My user wants to automatically populate the other text
from the value of the first one.
Assuming there are 3 records created.

Ex:
Text1 logdate
Client is out. 3/30/04
This is a test. 3/31/04
Request. 4/1/04

Text2
Client is out 3/30/04
Client is out 3/30/04. This is a test. 3/31/04
Client is out 3/30/04. This is a test 3/31/04. Request
4/1/04


I can only get the current value of text 1 into text2 but
not the previous values.

Thanks for the help.
 
Would you like to evaluate further.

Right now - this is my code:
Dim rs As Recordset
Dim lngMin As Long
Dim lngMax As Long
Dim Counter As Long
Dim strOrgseqno As String
'Dim strSQL As String
Dim varx As String


strOrgseqno = Me.txtorg_seqno

Set rs = Me.RecordsetClone


lngMin = DMin(rs("[phone_seqno]"), "tblPhoneLog")
lngMax = DMax(rs("[Phone_seqno]"), "tblPhoneLog")

Counter = lngMin
For Counter = lngMin To lngMax
varx = DLookup
("[comments]", "tblphonelog", "[phone_seqno]= " & Counter)

Next

Problem here is that I am not cycling thru the recordset
where strOrgseqno. It stays on the first seqno. Also, how
do I concatenate them in my for-loop?
Thanks for the advise.
 
Back
Top