J
JC
This one is stumping me.
I have a form that is used to process errors in orders. The first form is
the customer information and it has a subform to take down the specifics of
the error. I have the subform setup to be viewed as a datasheet that can be
used to enter data. The first field in the datasheet is the product code,
followed by description and then other data that is entered in each time.
I'd like to set it up, so that when the part code is keyed in, it grabs the
product code and description from another table and fills it in on the
datasheet subform (and saves it to the table that tracks all the corrections)
and then the user continues in entering in the data.
I was playing around with punching in the product code and then on exit of
that field, it runs an append query. That appears to be working, but I can't
get it to populate the description field.
Thoughts?
I have a form that is used to process errors in orders. The first form is
the customer information and it has a subform to take down the specifics of
the error. I have the subform setup to be viewed as a datasheet that can be
used to enter data. The first field in the datasheet is the product code,
followed by description and then other data that is entered in each time.
I'd like to set it up, so that when the part code is keyed in, it grabs the
product code and description from another table and fills it in on the
datasheet subform (and saves it to the table that tracks all the corrections)
and then the user continues in entering in the data.
I was playing around with punching in the product code and then on exit of
that field, it runs an append query. That appears to be working, but I can't
get it to populate the description field.
Thoughts?