update unbound control with VBA utils

[Francis]

Hello i need to write in VBA the following:


On Form Current Event i need the combobox: comboAgent to assume the
value obtained with the followig query (it only outputs one record so
its ok)
SELECT Agent_Table.agent
FROM Agent_Table, AgentSegment_Table
WHERE (Agent_Table.agentID = AgentSegment_Table.agentID) AND
(AgentSegment_Table.agentsegmentID = [Forms]![ARM]![comboSegment])


I think it will be needed to use the query method but i'm not familiar
with DataFactory and RDS (Remote Data Server) languages, if possible
try to use the more simple method to accomplish what i said previuosly
ok.


thanks in advance.
Francisco (Portugal)