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

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -