Update Query not working

[rehanemis]

Hi, Please have a look on the attached image. I have a table which contains Already Saved Styles. I would like to update the new table with already saved Styles where by considering form1 parameters. Style Type field always blank in new table so Style will be added to new table field using Form1.

Any suggestion please how query works?

 

[Uncle Gizmo]

I note your question has yet to receive a reply. Hence, I am bumping it up the list a bit so that it gets another Look...

 

[Ranman256]

Depending on table design and joins, it may not be able to run an update.

 

[Pat Hartman]

If Orderno_ItemNo is unique, you can join the two tables on that single field and update the permanent table with the value of StyleType.

If you need both OrderNo_ItemNo and PieceNo to define uniqueness, then draw two join lines between the tables.

Create a backup of your BE. Then zip it.
Use the QBE to build the query. Add both tables to the grid. Draw one or two join lines as needed.
Select the StyleType field from tbl_ShirtStyle.
Change the query type from Select to Update
In the UpdateTo field enter
tbl_Saved_ShirtStyle.StyleType as the "from" field
save the query,
Run it