Dlookup function not working, please help!!!

[michael_jacques]

Hi,

Basically im trying to set up a Dlookup on a form that uses the 'client
name' selected in a combo box, to display the clients Address 1 in the next
field, obtained from the tblclients table.

Iv tried using the build DLookup function as the control source, but it just
displays '#name?'. Whats going on??

Any help would be grately appreciated.

Kind regards,
Michael Jacques

 

[Sharkbyte]

Could you post the actual statement you are using? It would appear that the
db doesn't recognize table/column/something you are referencing in your
statement.

Sharkbyte