Controlling autosave

[Rosemary]

I have a form that adds records to a table that has 2 unbound dropdown boxes
to allow the user to select a POC and alternate for the new record. The
problem is that as soon as I click on the first unbound field to select a
value, ACCESS autosaves (inserts) the record. How do I control it so the
record only gets added when the "SAVE" button is pushed? The two unbound
dropdown boxes actually populate foreign keys in the main table.

Appreciate an help at this point.

 

[Douglas J. Steele]

What you're describing doesn't sound correct. Access doesn't autosave until
focus moves from the current record. Simply clicking on an unbound field
shouldn't save the record.

 

[Rosemary]

After reading your comment, I went back to try to figure out why it's doing
that, and I think it might be because when the user clicks the dropdown and
selects a value, I go out to the POC or ALT_POC table and bring back more
information about the person selected using a query in the Change event for
the dropdown box. It's only two fields and I guess I could just not display
them on the add.

 

[Rosemary]

I'm a moron - I copied the dropdown code from the edit form and there was a
me.refresh in the change event. I deleted that and it's working properly now.
Sorry.