forms - Input data into a table using DLookUp in Access -
i using data entry continuous form input data table named 'order_history'. fields input data table except one. have text box uses dlookup value combo box on form , use select data in hopes of entering table. dlookup getting data different table named 'postcodes'. assume reason others work because control source linked columns in table.
is there way can link text box (drop_number) specific column in order_history table while still using dlookup values?
my dlookup code:
=dlookup("drop_number", "postcodes", "postcode = [forms]![order_form]![postcode_cb]")
Comments
Post a Comment