updating a different field
if field2 is in the same table - place it also on same form, but make it
hidden
and in field1 exit event set field2 value
if filed2 in other table - then you have to run update query
--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
Quote:
> I currently have a form which has several fields in it.
> What I would like to do is, on the exit on field 1 I
> would like to put a numeric value in field 2. Problem is
> field 2 is in the table but not the form. How do I write
> the code so that if the answer to field 1 (ie is home)
> then field two automatically gets populated with the
> number 1 inside the table?
> Thanks
> Dan
