B
Bill
OK...It's like this.
I have a table that I update from VB (subform).
Lets call it tblMain.
The subform displays as a table (actually i run a make
table query every time the user makes a change. It looks
at tblMain and creates mtblMini which is what displays on
the subform).
one column on the subform is a combobox where the user
can change the value and almost instantly the SQL and
query are run and the results are displayed.
One last thing. what you see is filtered by company
which is selected from a prior form.
My problem is {when only one row is left for a given
company} when you try to change the value (what you would
expect to see after you release the combobox dropdown is
nothing. You could then go back and select the company
that you changed to and that record would appear there.
What happens is that as soon as you let go the record
vanishes and you get an error saying that Access has to
shut down and you may lose what you were working on.
Click OK and Access closes.
I have tried may variations of closing the form and/or
setting the recordsource to "" and then running my query
but I still get the same error.
As soon as this is solved we are ready to distribute.
Please Help!!!
thanks,
-Bill
I have a table that I update from VB (subform).
Lets call it tblMain.
The subform displays as a table (actually i run a make
table query every time the user makes a change. It looks
at tblMain and creates mtblMini which is what displays on
the subform).
one column on the subform is a combobox where the user
can change the value and almost instantly the SQL and
query are run and the results are displayed.
One last thing. what you see is filtered by company
which is selected from a prior form.
My problem is {when only one row is left for a given
company} when you try to change the value (what you would
expect to see after you release the combobox dropdown is
nothing. You could then go back and select the company
that you changed to and that record would appear there.
What happens is that as soon as you let go the record
vanishes and you get an error saying that Access has to
shut down and you may lose what you were working on.
Click OK and Access closes.
I have tried may variations of closing the form and/or
setting the recordsource to "" and then running my query
but I still get the same error.
As soon as this is solved we are ready to distribute.
Please Help!!!
thanks,
-Bill