Convert ComboBox Select Statement to TextBox Select Statement

[jjepsen]

I am having problems with list boxes not updating records so I want to try using a textbox instead. Here is the select statement I am using in the list box, any idea on how to write this so it iwll work iwht a text box?

SELECT [Part_Lookup].[NSN], [forms].[main].[part number] FROM Part_Lookup WHERE ((([forms].[main].[part number])=[Part_Lookup].[part number]));

 

[mac318]

Replace your periods with bangs(!):

Forms!FormName!FieldName

mac

 

[raskew]

Even after incorporating mac318's advice, there's nothing in your code that's going to update any records. All you're doing is selecting a particular group of records--not updating anything.

 

[mac318]

raskew is right on. You need to use an Update Query. Thanks raskew. I missed the select statement completely.

mac