If datapoint already exists populate form

[ADB_Seeker]

My data entry form has a unique field (PartNumber). When we receive quotes
from different vendors on a part, I enter that data into the DB. We may
submit a request for pricing on a part to multiple vendors, which means I
need to update the form with the new information instead of creating a new
record.

If I enter a part number that has already been entered, I need the form to
populate with the information already input for that part number so I can add
to it, thus eliminating duplicate part number records. I've searched posts
and found nothing that addresses this.

I hope this is clear and appreciate all responses.
Linda

 

[John W. Vinson]

My data entry form has a unique field (PartNumber). When we receive quotes
from different vendors on a part, I enter that data into the DB. We may
submit a request for pricing on a part to multiple vendors, which means I
need to update the form with the new information instead of creating a new
record.

Ummmm... no.

You're not updating a form. You're using a form as a tool to update a table!
Forms are *just windows*, not data repositories.

I think you may have a design problem: if you have a one (part) to many
(vendor prices) relationship, you need a second table, with fields for the
partnumber and the vendorID (and that vendor's price). Do you have such a
table, or are you using multiple fields in the parts table?

If I enter a part number that has already been entered, I need the form to
populate with the information already input for that part number so I can add
to it, thus eliminating duplicate part number records. I've searched posts
and found nothing that addresses this.

Use the "Combo Box" tool on the toolbar, with the magic wand icon selected.
Create a new combo box using the "Use this combo to find a record" wizard.

You don't want to *input* data into a new record; you just want to "move the
window" so that the table record for that part is being displayed. Your form
will then update the table. I'd expect to use a Form for the part, with a
Subform for the pricing information.

 

[ADB_Seeker]

John,
Thank you for your response. I have a table for Vendors & Vendor ID (key
field, autonum), another table called tblRFPTracking, which captures the part
number, vendor quotes, Request for Proposal code, etc.
It pulls information from the Vendors table to populate that information in
tblRFPTracking via a combo box.
I have a table "Engineering Drawing Numbers" that contains the part numbers,
date it was created, current revision, created by, description, etc.
We have over a thousand parts in this table so using a combo box to select
the part number is cumbersome. Besides, it wouldn't let me know if I already
entered a record for that part number.
If I enter a part number that is already in tblRFPTracking I need all
information for that part number to populate my form and I will add the next
vendor information to that form, thus adding it to tblRFPTracking.
My form allows input of up to five vendors for each part number of each
Request For Proposal number, which equates to a possiblity of 10 vendor
quotes on one part number. Instead of creating a separate record for the same
part number, I set the table up to populate all information from each vendor
on the same row for both RFPs.
I hope my information isn't confusing. I'm a beginner with Access.
Thank you for your assistance.