Populating Active Record from Form

[John]

Hi,

I've created a form that utilizes a drop down box with a
SELECT DISTINCT statement to pull information from a
record that I choose. After the information is pulled, I
have the option to enter in new information in other
fields, but when I save the record, Access puts the added
information on a new record in the main table. How can I
save the added information on the same record?

John

 

[Frank Stone]

if its not a bound form with an update query.