I am trying to figure out how some fields can automatically be filled in on a form based on an ID number selected from a drop down list.
For instance, let's say that Based on a JobNumber selected from a drop down I would like the SalesRepname, SalesRepcity, SalesReptype automatically filled in. This information is stored in a table that is updated every night from another database.
Table that imports info from another database fields are:
JobNumber
SalesRepname
SalesRepCity
SalesReptype
SaleType
SaleAmount
Then the form:
You select the Job number and SalesRepname,SalesRepcity, SalesReptype are copied over into the form.
However this is not the only information on the form. There are other fields that will be filled in by data entry by the user.
Once this information is automatically into the form, I want to store this information in the underlying table of the form. Therefore it cannot just link to the original table, it must be copied over to the new place.
What is the best way to do this. Query, Macro, write code?? Any help would be greatly appreciated.
Thanks in advance!!
For instance, let's say that Based on a JobNumber selected from a drop down I would like the SalesRepname, SalesRepcity, SalesReptype automatically filled in. This information is stored in a table that is updated every night from another database.
Table that imports info from another database fields are:
JobNumber
SalesRepname
SalesRepCity
SalesReptype
SaleType
SaleAmount
Then the form:
You select the Job number and SalesRepname,SalesRepcity, SalesReptype are copied over into the form.
However this is not the only information on the form. There are other fields that will be filled in by data entry by the user.
Once this information is automatically into the form, I want to store this information in the underlying table of the form. Therefore it cannot just link to the original table, it must be copied over to the new place.
What is the best way to do this. Query, Macro, write code?? Any help would be greatly appreciated.
Thanks in advance!!