R
Ron H
Hi, I am having difficulty in updating the source for a combo box. I have a
packing slip program that I have divided into two main tables. A table for
general info, Packing slip #, Customer, shipping address, shipping company
and date. The second table is the details of what part numbers, descriptions,
and quantities. In the entry form I have a combo box for the PO field, when
entered, some of the other data in the general info is updated using the
after update command. (A side question, what would cause these fields not to
automatically fill in until after I tab through them? Once I tab to them the
info shows.) I have a subform that is tied to the main form with the Packing
slip number. This is automatically assigned to each line.
I have made the field entry for the part number a combo box. The source code
is a query that will use the PO that was selected in the main form, and pulls
all the part numbers and descriptions. Once the part number is clicked on,
the description is automatically assigned. (Although it again does not appear
until after tabbing through). Now here is my main problem. When I need to
do a second packing slip, (a new record) that has a different PO#, the filter
in the subform does not “re-run” the query with the new PO number. It is
still pulling the part list from the last record’s PO. The only way for it
to update is to leave the form and reenter. I do not know how to get that
combo box to reset on a new record. If I leave the form open and just re-run
the query, it works fine. Just not in the combo box.
P.S. This is my first time posting, hope I wasn't too long winded. Thanks.
packing slip program that I have divided into two main tables. A table for
general info, Packing slip #, Customer, shipping address, shipping company
and date. The second table is the details of what part numbers, descriptions,
and quantities. In the entry form I have a combo box for the PO field, when
entered, some of the other data in the general info is updated using the
after update command. (A side question, what would cause these fields not to
automatically fill in until after I tab through them? Once I tab to them the
info shows.) I have a subform that is tied to the main form with the Packing
slip number. This is automatically assigned to each line.
I have made the field entry for the part number a combo box. The source code
is a query that will use the PO that was selected in the main form, and pulls
all the part numbers and descriptions. Once the part number is clicked on,
the description is automatically assigned. (Although it again does not appear
until after tabbing through). Now here is my main problem. When I need to
do a second packing slip, (a new record) that has a different PO#, the filter
in the subform does not “re-run” the query with the new PO number. It is
still pulling the part list from the last record’s PO. The only way for it
to update is to leave the form and reenter. I do not know how to get that
combo box to reset on a new record. If I leave the form open and just re-run
the query, it works fine. Just not in the combo box.
P.S. This is my first time posting, hope I wasn't too long winded. Thanks.