Populating a form field

[jeff1]

I have a simple form that consists of a combo box and several input boxes I would like the combo box to control what appears in one of the input boxes. The combo box is getting its information from a different table than that of which the form is being saved too.

 

[Terpsfan]

I would set the Control Source of the textbox control to equal what's in the combo box you are referencing. CboBox would be the name of the combo box.

TextBox1.ControlSource = [cboBox1]

 

[jeff1]

Omega36,

This gets me closer to my goal. I need to run a querry based on what is selected in cbobox30. The text box needs to be populated w/ data based on a querry. Example:

SELECT [My Table].FieldName
FROM [My Table]
WHERE [My Table].ID = [combo30];

How do I accomplish this. I am a newbe to access.

Thanks for your help

 

[JoeMiller]

This is the general statement for you to reference combo30:
[tt]
SELECT [My Table].FieldName
FROM [My Table]
WHERE [My Table].ID = [Forms]![MyFormName]![combo30];
[/tt]

HTH Joe Miller
joe.miller@flotech.net