Hi.
I have a database that needs to be modified and I'm kind of a newbie.
I have a form to be filled out that currently uses a query to fill four fields.
The user clicks a combo box (Sub/Vendor ID) to select a specific vendor and the 4 fields of Sub Vendor ID, Company, Address, and Taxrate are then filled in. The only value stored in the Work Order table is SVID and none of the values appear on the work order report.
The old form worked fine but they now want to use the companyname field as the combo box for selection to fill all 4 fields.
I thought I made the mods correctly, but the only field that gets updated is the companyyname field.
I'm actually at a loss as to how the fileds get populated from the original query but not from the query I made.
I can send a sample data base and 2 screen snapshots of the old and new forms.
Assistance would be greatly appreciated.
Thanks