I'm trying to populate a field (we'll call it field#2) on a standard form (Customer Record Card) automatically after I've selected the contents of another field on the same form (we'll call it field#1)
The content of field#1 is a pick-list lookup from a separate table. The other table also holds the look-up list I want to use to populate field#2. The relationship between fileds 1 & 2 is direct. Sounds simple ? It's driving me nuts.
I've tried using DLookup and I'm stuggling.
Can it be done using DLookup or another Built-in function or do I need more complex code.
Can anyone tell me what the syntax for the Dlookup function in the above scenario would be ... and where should I put it ? "on click" "after update".... ?
I'm using Access 2010
Help much appreciated