G
Guest
I have a form with an address combo box, when I select an address, I want
another text box ‘From_PostCode’ to update the corresponding postcode from
one of the columns on the combo box, but when I use the combo, I just get,
#name? appear in the ‘From_PostCode’ textbox
This is my code on the [From_PostCode] field set on the ControlSource
property
=DLookUp(" [PostCode]
","tbl_Street_Names","[StreetNameID]"=Forms!frm_Get_Rounds!FromGetRound.Column(3))
What am I doing wrong?
another text box ‘From_PostCode’ to update the corresponding postcode from
one of the columns on the combo box, but when I use the combo, I just get,
#name? appear in the ‘From_PostCode’ textbox
This is my code on the [From_PostCode] field set on the ControlSource
property
=DLookUp(" [PostCode]
","tbl_Street_Names","[StreetNameID]"=Forms!frm_Get_Rounds!FromGetRound.Column(3))
What am I doing wrong?