Populate Textboxes using SQL

[Pslice]

Is there a way to populate a textbox on a form depending on a combobox(This combobox is based on a column in a table) using SQL? I am currently using the Dlookup function, but want to know if there is some way I could use the SELECT statement.

 

[pbaldy]

No, but is this what you're trying to do?

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

 

[Pslice]

No, but is this what you're trying to do?

Yes I think that is what I want, I would have to see an example to confirm it though. Do you have an example on file?

 

[pbaldy]

Not offhand. It should be pretty easy to try though.