Recent content by Dave Taylor

Thanks to all, it now appears to work with the code below. I originally had 3 and not "3", but I had a problem. For some reason with "3" it still opened the popup form just fine so I had left it. I changed the revert line to Me.Undo and that seems to have done the trick. I think this was a case...

I have a pulldown field for Status tracking in a Service Records form. I want to interupt the update (hence using Before Update) if the status picked is "Completed" (ID 3) and open a pop up form to confirm that the user has completed certain tasks listed in the pop up. If Yes, the update to...

Thanks Simon, It is correct that I have 3 distinct addresses as a whole within the one Customers table. I can deal with the selection of which address to use depending on which function I am using in the database. The problem I am having is the 3 different countries (per record), or regions (per...

I would like suggestions on how to "properly" set up the tables and relationships required to do the following. We have a customers table that can contain a Country, ShipCountry, and BillToCountry. All 3 countries could in theory be different. I want all 3 to store the CountryID from the Country...