No tables in access. We directly write the VBA to SQL using unbound controls on most except for...my issue :).
I'll try to explain.
What I want to do is bind a RS from a sql call to a form.
Allow the user to change the data on the form.
Using the afterupdate event we will handle the data.
The form needs to be a continuous form.
On every SQL call we open, select and close the connection.
I don't want to use a temp table.
What is the best way for me to coax access to let this work?
1) Dump the Return to an array, loop and populate a an RS and bind it. This might work???
2) Somehow load the form and convince access it is closed and allow for trapping of the errors to edit the data.
Any help would be greatly appreciated.