Define Value

[Fernando Peixito]

Hello everyone,
I did a macro to define a value for one field in a form but I only can
define the value of one record each time and I would like that macro difine
the value for all the records of that field.

Any help greatly appreciated this is really annoying me!!!

 

[Nikos Yannacopoulos]

Fernando,

If you do it on a form, it will only update the current record, so you have
to scroll through all records! This method is appropriate for calculating a
field when entering data through a form, not for updating a field in an
entire table. If this is what you are after, then you should go another way:
make an update query on the table, and use a calculated field in it to
update the table field you want.

HTH,
Nikos