I
Ivar Svendsen
Hello.
If the contents of the field is not to be edited by the
user, you can set the control source property to something
like:
=DLookup("FIELD"; "TABLE"; "ID=5")
You could also use this in VBA code to initialize the
control:
TEXT1 = DLookup("FIELD", "TABLE", "ID=5")
(Note that the syntax changes: ';' is used in a controls
property field, but ',' is used between parameters in VBA)
Regards,
Ivar Svendsen
If the contents of the field is not to be edited by the
user, you can set the control source property to something
like:
=DLookup("FIELD"; "TABLE"; "ID=5")
You could also use this in VBA code to initialize the
control:
TEXT1 = DLookup("FIELD", "TABLE", "ID=5")
(Note that the syntax changes: ';' is used in a controls
property field, but ',' is used between parameters in VBA)
Regards,
Ivar Svendsen