PLEASE HELP! Dlookup event not working....

[emailloni]

Hello All,


I'm pretty new to Access and am working on a very simple dlookup. Taking the KAM (persons name) from one table based on a common Customer Name/Sold To into a form that I am creating. Please take a peak at my code below and help me with my error:

Private Sub SoldTo_AfterUpdate()
KAM = DLookup("KAM", "CustomerKam", "CustomerName= 'SoldTo'")
End Sub

I don't get an error AT ALL with this code but it doen't work. If I make the below changes after reading some other threads I get the standard error of 3464ata Type Mismatch

Private Sub SoldTo_AfterUpdate()
KAM = DLookup("KAM", "CustomerKam", "CustomerName=" & SoldTo)
End Sub


I cannot find any documentation on the special characters required for numerics vs text....can anyone provide?

Thank you SO much for your help!

Loni

[pbaldy]

This help?

DLookup Usage Samples

This may be easier if appropriate:

BaldyWeb - Autofill

[Bob Fitz]

Try:
KAM = DLookup("KAM", "CustomerKam", "CustomerName='" & SoldTo & "'")

[emailloni]

Try:
KAM = DLookup("KAM", "CustomerKam", "CustomerName='" & SoldTo & "'")

Dear Bob,
I tried and it's still not working, I'm not getting an error but it's not populating the lookup.

[pbaldy]

Have you set a breakpoint to test? To make sure that KAM isn't being assumed to be a variable (I assume it's on the form), try

Me.KAM = DLookup("KAM", "CustomerKam", "CustomerName='" & Me.SoldTo & "'")

I take it you didn't like my combo method?

[emailloni]

Have you set a breakpoint to test? To make sure that KAM isn't being assumed to be a variable (I assume it's on the form), try

Me.KAM = DLookup("KAM", "CustomerKam", "CustomerName='" & Me.SoldTo & "'")

I take it you didn't like my combo method?

That code didn't work either and I honestly don't know what you mean by "breakpoint to test". I just ordered $200 worth of training materials from Amazon and will get them in two days plus I signed up for level 1, 2, and 3 trainings with Illinois Computer Training. It just can't get here fast enough! Hopefully once I am properly taught everything will come together for me.

Thank you for trying to help me!

Loni

[pbaldy]

Can you post the db here?

[emailloni]

Can you post the db here?

I've just finished my three days of access classes and everything makes SO much more sense now. Thank you for your help, I'm posting another question today about linking a command button to a series of different folders on a shared network. My instructor couldn't help me..... :/ I have the links set up in a table as field Link

Loni

[pbaldy]

Happy to help. This issue is resolved?

[emailloni]

Yup, this issues is all good now (my relationships were not set up right). Anyway you can check out my post on the command button that I need to link to a shared network folder?

[BBonexx]

Hey Loni,

I am running into another issue quite similar. Could you please let me know what you did to solve your problem? Thank you,

Julio L. Toko

[emailloni]

Hey Loni,

I am running into another issue quite similar. Could you please let me know what you did to solve your problem? Thank you,

Julio L. Toko

Hello Julio,
Actually I found out that if you set up your relationships correctly, there is absolutely no need for any sort of dlookup. Becuase any table of information that is related to another can pull from eachother. It's quite difficult to explain but you don't need a dlookup at all. I actually took three classes on Access after this post from CTS and that is where I learned everything.
Good luck!
Loni