text box control source issues

[jlabre01]

Hi,

I want the following statement that I had as the control source for a combo box, but I want it to be the control source for a text box, there's some different formatting I'm not aware of to make it work, because it keeps saying there's an error, even though the statement worked for the combo box,

SELECT * FROM Companies WHERE Companies.CompanyID = Forms!Invoice!CompID;

please help, thanks in advance

jlabre01

 

[boblarson]

I think you are mistaken. This isn't a control source for a combo, it is a ROW SOURCE. You can't set a control source to be a sql statement.

 

[jlabre01]

oh ya, my mistake
but how would I make that the value of the text box?