G
garth.kirkwood
I have form with a single search field and Search button. I then
underneath have a subform that has no Master and Child link (I don't
need one).
The subform's RecordSource is set to a query and when you open it the
first time the datasheet view is exactly how I want it. The problem
begins when I have to update the underlying queries. I have to run a
Make Table query on the data in the search field specified earlier and
to do this I have remove the "SourceObject" run the Make-Table query
and then re-bind the SourceObject. The problem is that the datasheet
view fields go all hey wire and have some whacky order.
I tried to get around it by moving the function to a module but this
won't work either as the table is still locked even though you have
closed the form.
Could someone suggest how I can achieve what I need, thanks.
underneath have a subform that has no Master and Child link (I don't
need one).
The subform's RecordSource is set to a query and when you open it the
first time the datasheet view is exactly how I want it. The problem
begins when I have to update the underlying queries. I have to run a
Make Table query on the data in the search field specified earlier and
to do this I have remove the "SourceObject" run the Make-Table query
and then re-bind the SourceObject. The problem is that the datasheet
view fields go all hey wire and have some whacky order.
I tried to get around it by moving the function to a module but this
won't work either as the table is still locked even though you have
closed the form.
Could someone suggest how I can achieve what I need, thanks.