Master Form with tab control sort problem

S

Stan

I am using a master form with tab controls. The master
form is the property and the tabs all have information
related to that property. The subform are linked by the
property id in each table. I have 7 tabs which are
attached to subforms. When I sort on the first tab in the
last column which is date field the subform sorts without
a problem. When I used the pull down in the master form to
change properties, the database gives me a corruption
error asks to rebuild the database. I view the error log
that gets sent to MS but I cannot tell what is causing the
corruption. I can sort in all of the other tabs by any
field and than move on to another property by using the
pull down in the master form.

I have created a blank database and imported all of the
objects into the new database without success. I change
the way the subform is created from a query to a table. I
have created a test form with just the master table and
the problem subform and had the same problem.

Does anyone have a solution to this problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top