Still having problems with Form Search

[dan_mouse]

First, thank you to Elana and Jonathan Kok.
But I am still having some troubles.
I think that it would work except that I get a "The table is already opened exclusively by another user interface and cannot be manipulated programmatically." error.
This occurs when I try to have the form open another form. Even if I set the command button to close the current form first (this works) it will not open the second form (I get the error message).
I tried to set the database properties to:
Default Open mode = Shared and
Default Record Locking = No locks
in the Advanced Properties, but no luck.
I thought that by setting the first form's properties to Allow Additions = NO would fix this problem, but it did not.

Thanks again for your help so far.

-Dan

 

[Rich]

Sorry what are we talking about here?

 

[dan_mouse]

Oops, I forgot to reference this question.
It is a continuation of a post yesterday (Seven down on the list) with the subject "Search for existing records in a form"

Sorry for the confusion.

-Dan

 

[boblarson]

Dan:

If your table is the recordsource for a form and it is open, then another form cannot change the table's structure programatically at that time. It can change data, but not the table structure.

You have to make sure that there are no instances where the table is being accessed (no SQL in a combo box recordsource, etc) even if the form that is open itself is even an unbound form. Anything that is accessing that table will lock out programatical changes.

I hope that helps you find your problem.

BL

Oh, and as an aside, if you post into your previous post it helps keep all pertinent info there and the post will move to the top of the list.

[This message has been edited by boblarson (edited 05-01-2002).]

 

[dan_mouse]

Thanks for all of the help.
I have it working now.
I needed to set the Form properties to No Record Locks.

-Dan