Problem .. Instead of updating the changed record..the form adds another like record

[dmeid]

I am having a problem with a form. I have created a form, (in order to make changes to a Table) with the control source being a select query and not an actual Table. I created a combo box to search for the record along with the rest of the fields in that record. I search for the record to be Updated, and every time I try to change any field in that record and click on the next record, I go back to see if the change was made correctly, a new record is added instead of changing the record that I had retrieved.!!!! I do not have [Event Procedure] or any other type of command in the "After Update" or "Before Update" Does anyone have an Idea of what I am possibly doing wrong?

The reason WHY I don't use the actual Table as my control source is the fact that the Table is so large and the user only needs and wants to see only that certain category of records.

Any Help Would be greatly Appreciated!

 

[GJT]

You have almost answered this one yourself... you dont have to use the Table as the source you can use a query to present a filtered set of records to your form!

NB. I would not try doing it any other way - you will be making things more complicated than they need be. Bottom line - bind the control to an SQL query.......

 

[Rich]

Actually GJT it would appear that dmeid is using a query to return the records.
dmeid, try setting the allow additions property to no, though I suspect there is something wrong with the query itself, have you tried editing the data directly in the query?

 

[GJT]

Actually GJT it would appear that dmeid is using a query to return the records.
dmeid, try setting the allow additions property to no, though I suspect there is something wrong with the query itself, have you tried editing the data directly in the query?

rich - this is not apparent in his comments........"the actual Table as my control source"

 

[GJT]

GJT, I hate to get into a controversy, but the actual quote is, "I DON'T (sic) use the actual Table as my control source"

dmeid, the combobox that you are using for searching, must be unbound. I put the "search" combo in the form header and hide the combo in the detail section and only make it visible when the user is adding a new record.

I bow to your seniority - I misread his original comments......OK?

 

[dmeid]

I didn't want to get mixed up in the controversy..... but Pat & Rich you were right..... I am NOT using the TABLE as my control source due to the fact of minimizing my combo box listing for look-up purposes for the user.

Pat, I am going to try your suggestion, it makes a whole lot of sense.

I DO WANT TO THANK YOU ALL ...GJT... RICH...PAT FOR YOUR INPUT AND HELP..... YOU REALLY DON'T KNOW HOW MUCH IT IS APPRECIATED..... PARTICULARLY FOR US "JUNIORS" WHO ARE STILL TRYING TO GET OUR FEET WET......!!!!!!

THANKS A BUNCH ! dmeid