Search results

Hello everybody! I need Help!! When i try to run this set of VBA code: Private Sub Command24_Click() Dim BookingAvailable As Variant BookingAvailable = "Yes" If (Eval("=DLookUp(""[Viewing ID]"",""Viewing"",""Staff_Viewing_ID= Forms![Booking Screen]![AgentCombo] AND [Viewing Period]=...

Hey im new to the forums and desperately need some help! I am trying to run a macro which checks if the data which is being entered is already in the table, with error messages before running an append query at the end, however whenever i try to run the query i get a '2940 error' with all the...