Just had another thought if you really don't want to save the vendor in a vendor table. I still think you'd need it on the PO.
Your financial people would want it.
Anyway, there is a technique in other database systems to get info from a "system table". There is no such table in Access.
BUT this works
Code:
SELECT VendorId, VendorName FROM vendor ORDER BY VendorName
UNION
Select 9999,"FlyByNight" from (select count(*) from MSysobjects where 5=9)
This (select count(*) from MSysobjects where 5=9)
just gives the syntax to make the SQL valid. Since 5 never equals 9, no records are involved in MSysObjects.
The temp vendor will show up in the combo for selection.