dbProfileNew.zip
OK, I gave it one more try, actually several but i did get it to work. Not sure if its the correct method but it does work, Attached new copy of it working.
So what i did was on Form_Current i moved the Me.CboAddressType.Requery after the CboLocation = DLookup.... and then I Put this code in
Code:
Private Sub CboLocation_AfterUpdate() Me.CboAddressType.Requery
CboAddressType = DLookup("AddressID", "CompanyAddressByLocationQry", "CompanyLocationID=" & [CboLocation] & " AND Preferred=True")
If IsNull(CboLocation) Then
CboAddressType.Enabled = False
Else
CboAddressType.Enabled = True
End If
End Sub
Which is the same thing i have in the Form_Current so i am thinking this is most likely not correct method. I am sure there is some rowsource = stuff or something that would work better so if you have anything, please let me know. I would love some advice here.
Thanks