Guys - I have a simple form that queries an underlying Table. This form is called from a combo-box based in the "NOT IN LIST" event, which is done from another rather large data entry form. The query simply returns the max value in the table based in a parameter in the query. When the user types in a value that is not in the list, this form is opened, and returns the new value which is the max value based upon the parameter the user entered, and returns the result to the user in the form...as shown below (hopefully my screen print will post) All is good in the world at this point.
Problem statement 1: I as a user need to have this same value returned in the form/query added to the underlying table from which the query producing the result below is based.
Maybe I'm having brain freeze, but I cannot figure out how to get this value to the table. I cannot base a form on an Append Query. And if I use an append query as an action on the form, then I'm simply creating a duplicate process.