Subform fields changing

[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.

 

[garth.kirkwood]

Don't worry I was able to change my Make table query to a regular
select query and got it to work that way.