Good Morning all,
This is my first time posting and I'm fairly new at VB, here goes.
1. I have a listbox attached to a query
2. On the dblClick event i have code that opens a new form and populates fields based on the query results.
3. I need the query results to write to a table attached to the form that opens. Currently, it is incrementing the autocounter but abondoning the record.
4. I think i need some type of code that clones the record(query result) and AddNew method to write to the table.
Any suggestions? Anyone know the code to open a form, clone a record from the listbox, write the listbox query results to a table?