autofill in a form

[cosmicslop]

how can I automaticly fill in textboxes using what users put in in previous textboxes
this is how the form looks like
Ref date inf inf2
8347 12/02/2002 loi amd
8348 12/02/2002 fre xls
8348b 12/02/2002 hoi pap
8349 13/02/2002 fre amd

no suppose user would change date on line 8348 to 14/02/2002 I would like 8348b date also changed into 14/02/2002 automaticaly
is this possible?
all information welcome
Miguel.

 

[tomj]

Create a event procedure on the field being changed for the 'on change' property. Thus, if the field you are changing is called "DATE1" and the field you want updated is "DATE2" to match DATE1 then the event procedure would be:

Me![DATE2] = [DATE1]

 

[cosmicslop]

It's not that easy... the example shows 4 different records in one form I would like to find out how to perform a search on the 1st kolom thus finding out wich references have the same 4 beginning numbers if so the date in this case 12/02/2002 which would be changed on record 8348 should also be changed on the next record 8348b the date text box troughout this form has the same name.
it's even difficult trying to explain what I want it to do ...
still all opinions are welcome.
Miguel.

 

[Fizzio]

Are the textboxes different fields on the same form or part of a continuous form ie multiple rows of the same fields?

 

[cosmicslop]

they are part of a continuous form ie multiple rows of the same fields

the text boxes are the same but different record in contiuous form i've now been looking at the lookup function to get there
but this doesn't work

[This message has been edited by cosmicslop (edited 05-23-2002).]

 

[cosmicslop]

can I add an extra criteria in the lookup expression wich could decide if the field should be changed or not something like dlookup"[field]","table","[id]=forms![form1]![id]-1 and Rtrim[ref]=forms![form1]!Rtrim[ref]-1 ??? or is this absolutely not done