G
Guest
I am using Access 97. I have a database that is used to schedule inbound
appointments. On the scheduling form, one piece of information required is
the vendor name. I am using a look up box to the vendor table.
When the carrier arrives with the load, we use another form to input
relevant information for the load. This form is based on a query of the
appointment schedule. We enter the Probill number and a combo box matches it
to the record with the matching probill.
Here's the problem, it works fine for any vendor that is already on the
vendor table. If I use the Add Vendor form to add a new vendor, the vendor
will appear in the lookup box on the scheduling form, however the record will
not appear in the query.
Any help would be greatly appreciated.
Thanks,
Linda
appointments. On the scheduling form, one piece of information required is
the vendor name. I am using a look up box to the vendor table.
When the carrier arrives with the load, we use another form to input
relevant information for the load. This form is based on a query of the
appointment schedule. We enter the Probill number and a combo box matches it
to the record with the matching probill.
Here's the problem, it works fine for any vendor that is already on the
vendor table. If I use the Add Vendor form to add a new vendor, the vendor
will appear in the lookup box on the scheduling form, however the record will
not appear in the query.
Any help would be greatly appreciated.
Thanks,
Linda