Self Populating fields based off primary key

[ANJIBA]

I have been trying to use the Dlookup function to make fields self populate after selecting the "property code" - which is the primary key - from a drop down list. I keep getting errors. Is the Dlookup function the right tool to use in this situation? If so, can somebody explain the components of the function, maybe I am not using it right. I thought the expression is the item we are looking for, the domain is where we are looking and the criteria pinpoints what value in that domain to return.

=DLookUp([Market],[Prop_Mast_Tbl],[Prop_Mast_Tbl]![Market])

this formula results into the folowing error

"The object does not contain the Automation object "Prop_Mast_Tbl"


I don't see how this could be considering that I used drop down menus to build the expression. First timer at it so I could be making some really silly mistakes. Please help...

 

[John Big Booty]

Check out the syntax of the DLookup() function.

Your code should probably look something like;

=DLookUp("Market","Prop_Mast_Tbl", "Market = " & Me.Market)