Dlookup from another table in form not working

[ascool_asice]

Hi to all



I am pretty new to access and this is the first database that I am trying to build after reading and watching a few video's online.

The attached access file has only one form called 'caller' in it and that is the form I am having an concern with

The form has a field called 'propertystatus' which I need it to populate from the table 'properties' I was wondering if someone could tel me why this dlookup is not working...

Appreciate your help and support

Thanks

[June7]

Why does the Relationships builder have two copies of Property table joined to same field in Caller table?

The dynamic parameter is within quote marks. Quote marks indicate literal text. Don't put variables within quotes.

Also, the value of PropertyAddress combobox is ID, not PropertyAddress.

DLookup("[Status]", "Property", "[ID]=" & [PropertyAddress])

However, DLookup and VBA are NOT needed just to show value from Status. Include the Status field in the combobox RowSource. Change ColumnCount to 3 and ColumnWidths to 0";1";0.

Expression in textbox ControlSource: =[PropertyAddress].[Column](2)

[ascool_asice]

Hi June7

Thanks... The dlookup worked perfectly...

Spent a lot of time on the other method that you have mentioned however could not get that to work.. if you are aware of any link which can help me that it would be great

[June7]

Why wouldn't it work, what happens - error message, wrong results, nothing?

Properties of the combobox:
RowSource: SELECT ID, PropertyAddress, Status FROM Property ORDER BY PropertyAddress;
ColumnCount: 3
ColumnWidths: 0";2";0"

Expression in textbox: =[PropertyAddress].[Column](2)

At least could eliminate the VBA and put the DLookup expression directly in textbox ControlSource.

[ascool_asice]

Hi June7

I am not getting any error the text box remains blank..

Attached the file again with what I have put in...it would it be awesome if you could check whats wrong with it...

[June7]

Column index begins with 0. The status is in third column so that is index 2.

=[Contract Propert Address].[Column](2)

Also need to check the Show box in the RowSource query for the Status field.

[ascool_asice]

wow this did it thanks a ton June7.