Which Event?

[mark curtis]

I use a text box to enter a projectID and then a Select SQL to populate the rowsource of a list box, which can be clicked to open related form. I want to place one of the column values in a textbox on the search form but I am unsure which event to use?

I used AfterUpdate but it does not populate the textbox until I select a record on the listbox, view the form it opens and then go back into the textbox?

Thank
Mark

 

[R. Hicks]

Sounds like the line you are using to populate the txtbox is after the line to opens the form ... move the line to populate the txtbox above the line to opens the form.

HTH
RDH

 

[mark curtis]

Thanks I probably waffled on.

When I load a form how do I ensure that a textbox always shows the boundcolum(1) value even if the listbox shows nothing?

 

[R. Hicks]

If there is nothing selected in the listbox .. there will be nothing to populate the txtbox with ....

RDH