Search results

Adding the ME.Requery to the AfterUpdate Event Procedure fixed my issue. Thank you missinglinq. I would also like to thank Pat Hartman for the time spent on this problem. I know when it comes to this stuff, there is always more than one way to skin a cat. I'm going to test this thing out...

I made the changes you suggested: 1) Deleted the entirety of the "Click" Event. 2) Adjusted the syntax to what you suggested, (see updated code) I am now receiving a "missing operator" error. Specifically, "Run-Time error '3075': Syntax error (missing operator) in query expression...

Thank you for your responses, Linq and Pat! Here is the code for the Form_AllTabs: Option Compare Database Private Sub EquipmentGroupCombo_NotInList(NewData As String, Response As Integer) On Error GoTo Err_EquipmentGroupCombo_NotInList ' Allows user to add a new Equipment Group by typing...

Good afternoon, Access Forums! I am an IT Technician for multiple firms in Port Angeles, WA. I have a little experience with Access from building a Purchase Order database for a Housing Authority, but this build was over 7 years ago, and I am quite out of touch with the application these days...