Auto Populate Fields based on Combo Box selection

[BSAS_itguy]

I have a combo box that auto populates address fields, based on the Vendor ID that is chosen.



All the field son the form are based on a header table for the shipment, the combo box is controledby the vendor table in order to auto populate the address fields.

Now the form will not allow you to save a new record. It comes back with this long error message:

"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the data in the field or fields that contain duplicate data, remove the index or redefine the index to permit duplicate entires and try again."

[NTC]

ok - well your post title and your error message are 2 different topics.

concerning your error message; this is one case where the error message is accurate and informative (which can be rare ! ).

the table that is the ultimate record source for this form has one of your fields set up so there can be no duplicates. something about your combo selection or whatever you are doing as the user in the form is causing a duplicate value to go into that field.

so you have to stop that from happening - or - go to the table and change the setting to allow duplicates. Only do the latter if you own this application and have the insight to know that this change won't truly screw things up....as having duplicate values in a column that should not can be a very important point.

Hope this helps.

[BSAS_itguy]

OK, I guess I started this on my own before I learned how to do it. So here the question so I may start the form over again.

If my user is preparing a new shipment on the form. With all fields blank I want them to be able to type in the Vendors Account number and automatically return the address fields. If the Vendor is not in the database then they will type it in and it will be in there for future use.

Then they can procede to fill out the rest of the shipment data to create a new record.

My 3 tables are Shipment.Header- Primary Key-Voucher#
Shipment.Lines- Primary Key-Autonumber
Shipment.Vendors- Primary Key-VendorID

VendorID is in the Shipment.Header table also.