Picture didn't come through. You might try posting the SQL of it.
Who is John Galt?
Windows XP 
Access 2007
Picture didn't come through. You might try posting the SQL of it.
Competent Performer
Windows 10 Access 2016
UPDATE [Suspected Activity] SET [Suspected Activity].Region1 = [Forms]![frmSub Suspected Activity]![IDCountry]=[Country List]![Region List]
WHERE ((([Suspected Activity].[Number of Incident])>"30000"));
Who is John Galt?
Windows XP Access 2007
You've got a form in there. Try this, create a regular query and join the two tables. That will get you the correct syntax to join them. Then change it to an update query, select the table/field to be updated and put the table/field in the Update To area. If you want, post a sample db with just those 2 tables and a few records of junk data.
Competent Performer
Windows 10 Access 2016
Thank you so much for all the help!!
Who is John Galt?
Windows XP Access 2007
No problem! Got it working?
Posting Permissions
Reply With Quote