Recent content by cosmicslop

is there somewhere a site where i can find help on using recordsets?

Hi, I'm very new at this and I am struggling to make some kind of code in order to fill up a field automaticaly when it corresponds with some criteria. In a continuous form, On exit of field3 I want to check if the rtrim of field2 from the current record corresponds with the rtrim of field 2 of...

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

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).]

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...

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...

ok do not bother sending it got it from the site thanks a million

can you copy me too please?

I would like to be able to fill in some text fields in a continuous form. I have one number that is unique, the fields that should be filled in automaticaly could be already filled in or be blank. the unique number looks like this zee001234a then zee001234b, etc. now i would want the user to be...