MS Access Change Event Not Firing

I am running the Change Event below to populate standard contact information. This has worked well when I select a name from the drop down menu. However, often times I just start typing the Account to find the correct one since it can be faster than scrolling through the Account list. However, when I tab or click to the next field its not recognizing the change and doesn't fire. What am I missing?

Private Sub cboAccountID_Change()
' Adds Account info to invoice
    Invoice_To = DLookup("Invoice_To", "tblClientLists", "AccountID =" & Forms![frmInvoices]!AccountID)
    Invoice_Email = DLookup("Invoice_Email", "tblClientLists", "AccountID =" & Forms![frmInvoices]!AccountID)
    Service_Type = DLookup("Service_Type", "tblClientLists", "AccountID =" & Forms![frmInvoices]!AccountID)
    Client_Rate = DLookup("Client_Rate", "tblClientLists", "AccountID =" & Forms![frmInvoices]!AccountID)
    Address = DLookup("Address", "tblClientLists", "AccountID =" & Forms![frmInvoices]!AccountID)
    Unit_Suite = DLookup("Unit_Suite", "tblClientLists", "AccountID =" & Forms![frmInvoices]!AccountID)
    City = DLookup("City", "tblClientLists", "AccountID =" & Forms![frmInvoices]!AccountID)
    State = DLookup("State", "tblClientLists", "AccountID =" & Forms![frmInvoices]!AccountID)
    Zip = DLookup("Zip", "tblClientLists", "AccountID =" & Forms![frmInvoices]!AccountID)

Answers


i think that because you are typing you are not actually changing/submitting anything. so the code has to be changed slightly from

Forms![frmInvoices]!AccountID

to

Forms![frmInvoices]!AccountID.Text

(i'm not sure how the lookups will respond as you type.)


Need Your Help

python: list modules within the package

python import module packages

I have a package with a few modules, each module has a class (or a few classes) defined within it. I need to get the list of all modules within the package. Is there an API for this in python?

Prevent access to certain libraries in dart

dart dart-native-extension

Is there a way to prevent access to certain libraries in dart? The reason why is I want to allow a scripting language in my application. It looked like dart would make that easy, by just limiting w...