Set a text box value

[Guest]

Hello.. I have a form, with a subform. On the form I have put a command
button that I want to click to update a text field on the subform. The value
for that field will come from a field name in a table that is not involved
with the main form, or the subform. The table holding the needed information
has only one row. Can someone help me with the VB code.

 

[Allen Browne]

To get the value from the table, use DLookup()

See:
Getting a value from a table: DLookup()
at:
http://members.iinet.net.au/~allenbrowne/casu-07.html

If you are stuck knowing how to refer to the text box in the subform, see:
Referring to Controls on a Subform
at:
http://members.iinet.net.au/~allenbrowne/casu-04.html

 

[Guest]

Thank you!

To get the value from the table, use DLookup()

See:
Getting a value from a table: DLookup()
at:
http://members.iinet.net.au/~allenbrowne/casu-07.html

If you are stuck knowing how to refer to the text box in the subform, see:
Referring to Controls on a Subform
at:
http://members.iinet.net.au/~allenbrowne/casu-04.html