Trying to update a field on a form to help the user when entering data (1 Viewer)

[Jon123]

I am trying to update just 1 field on a form. I has a temp table and I just want to display the history based off what serial number is selected. Iwas trying to put this code in the control source for that field.

 =DLookup("[temptablekitmove]", "[Parthistory]", "[Serial Number] = [part1c]")

 

[WannaKatana]

What is [part1c]?

Sent from my SM-N910V using Tapatalk

 

[Jon123]

that would be the [serial number] on the form

 

[WannaKatana]

=DLookup("[temptablekitmove]", "[Parthistory]", "[Serial Number] = '" & me.[part1c] & "'") if a string value.

=DLookup("[temptablekitmove]", "[Parthistory]", "[Serial Number] = " & me.[part1c]) if numeric

Sent from my SM-N910V using Tapatalk

 

[Jon123]

so I moved this code to the on open event of the form

Me.[part1history] = DLookup("[Tble-Qtz Kits All parts]", "[Part history]", "[Serial Number] = '" & Me.[Part1c] & "'")

When the form open I'm getting an error that access cant find input table or Query Part history ???

 

[Jon123]

Got it, Thank you for the help

Me.[part1history] = (DLookup("[Part History]", "Tble-Qtz Kits All Parts", "[Serial Number] = '" & Me![Part1c] & "'"))

 

[Minty]

As a word of advice whilst it won't be too painful - Remove all the spaces and any special characters from your field names.

As you have already discovered it adds the possibility of Typo's and adds loads of extra typing to your code. Get your self a naming convention and stick to it.
https://www.access-programmers.co.uk/forums/showthread.php?t=225837