Populate a textbox from table field (1 Viewer)

[mikesp1234]

I am trying to populate a textbox from a field in a table based on clicking on a item in a listbox. User clicks a name from the Client table in the client field, and the date that is stored in the orderDate in the same row. I want the text11 textbox to show that date.

 

[pr2-eugin]

Are you talking about AutoFilling the information?

 

[mikesp1234]

Yes. Based on the date stored in the feild of the table. Same id number

 

[mikesp1234]

I have tried lots of options. Its just getting it to update on the onclick function for the listbox. Thats the problem

 

[pr2-eugin]

Sorry if it was not clear it was a Hyperlink to some help on Autofill.. Check the Link..

http://www.baldyweb.com/Autofill.htm

 

[mikesp1234]

I know I read it. But it still isn't updating the textbox. I tried that method already.

 

[pr2-eugin]

What is the RowSource of the ListBox..

 

[mikesp1234]

it is the client field from the client table

 

[mikesp1234]

Perhaps this is sounding too complicated. I have a form with a listbox and when I click on a different name, I want it to change a textbox to have the information from a different field in the same row. So if I click the name Mike the "date"(which is a field) in the textbox should change, click Tom should change again, and so on.

 

[pr2-eugin]

Okay, go to Form Design mode. Click on the ListBox, under Data tab there should be something called the RowSource.. It would be a SELECT Query.. Copy and paste it here..