Recent content by ricardocpa

I apologize, @Mark_ , I am not versed in VBA at all, could you please expand on "Validate in the BeforeUpdate event"?

Mark, the Save button runs a private sub that checks some mandatory fields have a value and then performs a Save Record command if the record state is dirty, as follows. My guess is that an error occurs during DoCmd.RunCommand acCmdSaveRecord. Again, this sub runs fine in the previous version...

This is a great question - although I believe the form is bound to the Facility table

Thank you @theDBguy - The form is bound to the Facility table. I am not using any code behind the new textbox, as you guessed with your question the error only appears when clicking on the button 'Save'

I am working on a local copy of an Access file that only operates with tables linked to a SQL server. This file works with no issue, but recently a new table 'Subbasin' table has been added, and a related field has also been added to an existing parent table 'Facility': My goal is to add, in...

Hello there! Ricardo Carmona here, from California, I am currently a Hydrologist working for an agency that manages water resources. I work with teams that gather water and groundwater data; I have been working with Access databases since I was out of college; I am also an experienced business...