Recent content by JohnnyJones

Sorry I'm quite new to access and vba and I'm having an issue with the highlighted part of my code. The error I'm getting is "data type mismatch in criteria expression". Can anyone see what the issue is here? Private Sub BtnAddBooking_Click() Dim CustomerID As String Dim StaffID As String Dim...

Thank you, that was the issue!

I use access occasionally but wouldnt be the greatest developer. My head is stuck to find out why the Invalid Qualifier error keeps occuring. If anyone could see why that would be a huge help. This is the code, and I've highlighted the line where it says its invalid qualifier: Private Sub...