control source problem

[snowman]

ok guys very simple question

i have manually built my form in Access 02. Now i want to bind a particular control to a table - ie. when the user hits 'Submit' the record will get written to the correct tables. simple data entry

i have a table called tblShipping, in which there is a field called Goods. in the control source i have the expression: =[tblShipping]![Goods] but this is not working. in the text box (in normal view of my form) appears: "#Name?"

what am i doing wrong?

 

[RuralGuy]

Set the RecordSource of the form to a query of your table (bind the form to the query). Then use the DropDown on the ControlSource of the control to select your field.