How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask NewITZone Your Own Question
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I need to copy data from physical address fields in a table

Customer Question

I need to copy data from physical address fields in a table to mailing address fields in the same table if a checkbox is selected on a form. It seems like this would be very easy; however, I keep trying different things and nothing works.
When I click on the checkbox on my first record in the form, nothing gets updated. When I go to the second record on the form and select the checkbox, the first record in the table gets updated instead of the second record in the table. Also, I can’t get the updated records to show on the form when the checkbox is selected even though the new updated records get updated in the table.
Right now I have a macro attached to the On Click of the checkbox and the macro is supposed to run a SQL query.
My SQL query is:
UPDATE tblVenues
SET ContactMailingAddress = ContactPhysicalAddress, ContactMailingSuite = ContactPhysicalSuite, ContactMailingCity = ContactPhysicalCity, ContactMailingState = ContactPhysicalState, ContactMailingZip = ContactPhysicalZip, ContactMailingCountry = ContactPhysicalCountry
WHERE ContactMailingAddressSame = true;
My macro is:
Qry Name: qrySQLUpdateMailingAddresses
View Datasheet
Data Mode Edit
Stop Macro
Any help would be greatly appreciated.
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Bhavik Joshi replied 1 year ago.

Hi Welcome to JustAnswer

Expert:  Bhavik Joshi replied 1 year ago.

I will look into it and get back to you.

Expert:  Bhavik Joshi replied 1 year ago.

Can you send copy of it to me ?

Customer: replied 1 year ago.
I keep getting an unknown error message when I try to attach the file. I called the Support Department and they asked me to send an email to***@******.*** with the file attachment. I have also asked them to change my needs to high priority.
Expert:  Bhavik Joshi replied 1 year ago.

please send it to me on***@******.***