I can't get this line of code to work. <br><br>table net_download has<br>fields onloan and settleloc<br><br>Table sdave has<br>fields loc<br><br>DoCmd.RunSQL "update net_download set onloan = table![sdave]![loc] WHERE settleloc = tables![sdave]![loc];"<br><br>When I run this it asks me for the parameter value for tables![sdave]![loc]. I have tried different configurations but I can't seem to update the onloan field net_download when the settloc field is equal to the loc field in sdave.<br><br>Can you help?<br><br>Thanks a lot!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL in VBA - how to update a table with info from another
- Thread starter davo
- Start date
You are better off asking this in either the MS Access or Visual Basic fora:<br><A HREF=" TARGET="_new"> HREF=" TARGET="_new"> is probably a problem with the way your SQL string is constructed.
- Status
Similar threads
- Locked
- Question
