Search results

Oh my goodness, thank you. What is the purpose for Me. ? When is it best to use that?

I'm sorry but I dont understand how this code works. When Im in Form View and change the city Meriden zip field to 10050 it stays the same, when it should change to 10050-0050. Sorry if this is confusing.

I changed it to this. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ZipFirstFive As String If Not IsNull([City]) And Not IsNull([Zip]) Then ZipFirstFive = Left([Zip], 5) Select Case [City] Case "Meriden" If ZipFirstFive = "10050" Then...

Hello, I'm having trouble understanding how to autocomplete something using VBA Form_BeforeUpdate. This is a practice exam I took a few days ago, and I still don't understand this piece. The example my Professor gave is to pretend that I was told that the Zip field for Meriden have changed from...