Greeting to All Experts,
I have a series of forms. When a user creates record on one subform and click a button a sQL insert statefires without error. However, when I look at the table, I don't see the record inserted. When I open the next form (which is not a subform) which relies on the record the form query returns null, of course.
Does Access SQL require a commit statement? Do I need to refresh? requery?
I'm really very frustrated with this and hope one of you can help me.