Hi All,
In a Form I have a ComboBox called Agent and two text boxes called :
Supervisor and ID.
When I select an Agent from the ComboBox the name of the Agent's
supervisor and his ID are displayed in the Text Boxes. I use a Dlookup
for both text boxes :
Supervisor :
=DLookUp("Supervisor","FSO FRANCE","Name = '" & [Form]!Name & "'")
ID
=DLookUp("ID","FSO FRANCE","Name = '" & [Form]!Name & "'")
My question is : How do I assign the values in the text boxes to one of
the Table called T_General (I have two fields called Supervisor and ID
in this table)
Thanks in advance for your help
Olivier
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
