I am working on a project with an Access 2000 DB using ADO. I have a form that has mainly text boxes bound to fields in the DB. However, I need to have the have the option for the user to select some items from a drop-down (eg. State) and then be able to save the changes to the DB. After selecting a new value from this drop-down, and then attempting to update the recordset, after the .requery, I get a run-time error 3219, "Operation not allowed in this context" Am I doing this all completely wrong?. If this form is just used as an interface for entry/edit to the DB, do I need to explicitly open a new recordset and populate all the controls on the form? Any help would be GREATLY appreciated.
War Eagle,
AU Student
