L
Lin Light
I have a form that is based on two tables one is Orders the other Invoices.
The combo looks in the Order table for PO numbers and then brings along to
the form the Order's Vendor Name. Basically it is working, BUT. When I enter
in the PO number say 5528, and hit the enter or tab key, 5524 appears. I
entered in a number of PO numbers and many of them would change to 5524 as so
as I hit enter or tab. I found what they all had in come, was they all had
the same Vendor. This also works off the list, I will select 5528 and 5524
would appear in the data box. So how do I get the combo box to accept the PO
number as entered?
Lin
The combo looks in the Order table for PO numbers and then brings along to
the form the Order's Vendor Name. Basically it is working, BUT. When I enter
in the PO number say 5528, and hit the enter or tab key, 5524 appears. I
entered in a number of PO numbers and many of them would change to 5524 as so
as I hit enter or tab. I found what they all had in come, was they all had
the same Vendor. This also works off the list, I will select 5528 and 5524
would appear in the data box. So how do I get the combo box to accept the PO
number as entered?
Lin