DLookup from Another Table

[SteveHale]

Hello everyone.



My brain has deserted me.

1. I have a Form that auto-populates the Field "Processor" and the Record Source is called "tblLog".

2. Upon "Processor" being populated, I would like to have 2 text fields auto populated as well, "Unit" & "UnitCode".

3. I have a dedicated a Table called "tblProcessors" that houses the "Unit" & "UnitCode" information. "tblProcessors" also has a "ProcessorInitials" field in where the values are identical to the values of "Processor" in the "tblLog" table.

4. Here's what I have done:

Me.Unit = DLookup("Unit", "tblProcessors", "Processor = " & [ProcessorInitials])

Any help is greatly appreciated and you all would be my MS Access Santa Claus. Thanks in advance.

Merry Christmas and Happy Holidays!

- Steve

[CJ_London]

you could just put

= DLookup("Unit", "tblProcessors", "Processor = " & [ProcessorInitials])

in the controlsource of your textbox, then you don't need any code

my other comment would be that ProcessorInitials sound like it is text in which case you would use

= DLookup("Unit", "tblProcessors", "Processor = '" & [ProcessorInitials] & "'")

[SteveHale]

you could just put

= DLookup("Unit", "tblProcessors", "Processor = " & [ProcessorInitials])

in the controlsource of your textbox, then you don't need any code

my other comment would be that ProcessorInitials sound like it is text in which case you would use

= DLookup("Unit", "tblProcessors", "Processor = '" & [ProcessorInitials] & "'")

Ajax!

You are Santa Claus!!!

Thanks Sant..., I mean Ajax!!!