Changes made in form are not applied to record selected

S

Susan L

I have a pop-up form which I want to use for changing existing data. The
record source is a table. On the form there is a combo box to choose a US
state. The query contains all fields that I want to use on the form. I then
have code in the after update event of the combo box so that the data appears
in the appropriate form controls.

The proper data appears when I make a selection in the combo. However, when
I make changes to the data, the changes are applied to the very first record
in the table (Alabama), not to the record selected from the combo (Utah). And
when I reopen the form, what is showing is the full state name, not the
abbreviation. The full name is not even in the query (but is in the table).
The PK is ID, which is not currently in the query – but was earlier. I have
also compacted the db several imes.

Here’s the query:
SELECT tbl_Tab2_SiteList.StateAbr
, tbl_Tab2_SiteList.City
, tbl_Tab2_SiteList.MCICircuitID
, tbl_Tab2_SiteList.LECCircuitID
FROM tbl_Tab2_SiteList
ORDER BY tbl_Tab2_SiteList.StateAbr;

Any thoughts?
 
Top