database - DLookup in Access form not working -
i working form (numbers entry) inputs information table (numbers). first field in form combo box (property initials) allows user choose property entering information for. trying setup textbox on form provide information (# of models) table (property info) based on property chosen first field, combo box named property initials. believe dlookup
best way this, , have been trying no avail work properly. using following:
=dlookup("[# of models]","property info","property initials = " & [forms]![numbers entry]![property initials])
this returns #error
, i've tried gazillion different methods , none have worked. appreciated.
it's string variable, thus:
=dlookup("[# of models]","[property info]","[property initials] = '" & [forms]![numbers entry]![property initials] & "'")
Comments
Post a Comment