I've been through it many times and I understand what you're saying. Here it is:
If Not IsNull(DLookup("[field_1]", "tbl_detail_all", "field_1 = '" & Me.cmbo_scenario & "'")) And _
Not IsNull(DLookup("[field_2]", "tbl_detail_all", "field_2 = 'Accounts Receivable'")) Then
db looks like this:
field_1 XXX YYY ZZZ
AAA BBB CCC field_2
I believe my logic (condition on DLookuo) would INSERT my new data. Instead it skips over the insert (when I debug). Again, it appears that it is evaluating on two seperate rows in the db.
I know I'm wrong but I just can't figure this one out.
Thanks for any help.