Updating a record on a bound continuous form
Posted on 2012-08-12
I have a continuous form that is bound to a temporary table. When I open the form, in the on_load event, I populate this table with various SQL calls and then at the end of he on_load event, I do a Me.Requery and Me.Refresh. This puts the table contents on the screen in my continuous form. However, I am trying to figure out how to update the record when I change data. So far, I see that if I make my data changes and then move to another record on the form, then the updates work, but if I only have one record showing, there is no other record to go to and how do I get the data to update? (I have the AllowAdditions set to false, since I don't want users to be able to add records through this form.) I have added a button to the record called Update, but I am not sure what code to put in it to update the table?