Macro To Replace information in a field on a table

[JBurlison]

I need a macro that can Replace information in a field on a table. basicly i have a "Receiving" form with 10 spots for S/N's when the user "Saves" the infomation i want the "Location" to change to "SAI, Shelton" on my "Main Inventory" Form. or maybe there is VB code that can do this.

 

[ajetrumpet]

You should probably use either a stored UPDATE query or a the recordset method in VB. The query would probably be the best though.

 

[JBurlison]

How would I do that with a query would it replace the one field or the whole colmn?

 

[ajetrumpet]

Research UPDATE queries. You can update anything in a table with it. Use the help menu to figure out basic SQL statements if you don't already know them....