Requery Subform

[Ramone]

I have a form with a subform.

I would like the following to happen:

When I enter the agent ID in to txtbox1 and move to the
next control I would like the agents name to appeare in
txtbox 2 which comes from the subquery

Thanks for any help,


Ramone

 

[Ken Snell]

Why not use a multicolumn combo box instead?

See The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm