L
lmcc007
I have a query that I created from my tblAddresses. It has five fields:
1) AddressID
2) CompanyID
3) TypeofAdd_Lkp
4) MailingAddress
5) FullAddress (an expression)
I created a form from the query.
Now I am working with the TypeofAdd_Lkp field. This field has three
choices: Home, Business, Other.
So, if I choose Other, I want the address to show for Other; if I choose
Business, I want the address to show for Business and so on.
I entered the following code on the TypeofAdd_Lkp field--On Click, I entered
an Event Procedure.
Private Sub TypeofAdd_Lkp_Click()
Dim AddressChoice
AddressChoice = DLookup("[TypeofAdd_Lkp]", "qryFullAddress",
"[AddressID]")
End Sub
It is not doing anything. Did I miss something?
Thanks!
1) AddressID
2) CompanyID
3) TypeofAdd_Lkp
4) MailingAddress
5) FullAddress (an expression)
I created a form from the query.
Now I am working with the TypeofAdd_Lkp field. This field has three
choices: Home, Business, Other.
So, if I choose Other, I want the address to show for Other; if I choose
Business, I want the address to show for Business and so on.
I entered the following code on the TypeofAdd_Lkp field--On Click, I entered
an Event Procedure.
Private Sub TypeofAdd_Lkp_Click()
Dim AddressChoice
AddressChoice = DLookup("[TypeofAdd_Lkp]", "qryFullAddress",
"[AddressID]")
End Sub
It is not doing anything. Did I miss something?
Thanks!