I need to get a value from a table on to a form based on a value that exists on the form. The field being sought is part of the record being assembled that would be appended to a table. The only way I think I can get it is via an expression in the default value (properties) but have not succeeded. I have tried to use dlookup and select but the field starts out with #name? and then nothing.
Is default value the right place to do this? I'm thinking not.
Would appreciate some guidance.
Thanks