Populate a text Box Base on a drop down Selection

[Guest]

Hi,

I have a front end form with 2 fields on it. One is a combo box and one a
text box.

When I choose the Combo drop down and select a agent ID i need a text box to
pre populate with the agents name?

I currently have the Combo box pointing to one query and then the text box
pointing to another query based on the results of the combo box query. when
i select the id nothing appears in the Text Box.

Thanks

Mr Cranswick

 

[Guest]

I don't get the idea of binding the textbox to a query? If the textbox is
just a reference you could just use the afterupdate from teh combo:

me.textbox=me.combobox.column(1)

assuming you have two columns in your combo

if you do need to use the query for the textbox you have to set the criteria
in that query to the agentid from the form something like:

forms!formname!combobox
and after that you have to requery the textbox: me.textbox requery

hth

 

[Ken Snell \(MVP\)]

See this:
http://www.mvps.org/access/forms/frm0058.htm