Help with a corrupt database

  • Thread starter Thread starter Noel
  • Start date Start date
N

Noel

Hi. I wonder if anyone has any ideas on this one. My db
is doing something really odd. Briefly, I have a tab
control form, each page of which shows a different form.
Four of these forms all use the same subform to show
releted records. I have set up an Event to sort the
subform records in decending order by a certain field.
This works OK for all but one tab. This tabs subform
shows the records sorted in the reverse order. Ive tried
loads of things but cant see why this should happen -
after all the subform is common to all the forms and
exactly the same thing should happen for each one. I have
found an old Backup that does not have this problem but
Im getting really tangled up trying to isolate the exact
cause. Could this possibly be corruption and if so, are
there any tools available to help fix it? Ive tried
Compact and Repair but no luck. Thanks, Noel
 
Noel,

As far a I can tell, htis doesn't look like corruption. Corruption usually
pronounces itself in the form of bad / lost data, not design changes.
Since you have a backup in which the form behaves right, and assuming you
haven't made any other changes to the form since the backup was taken, one
thing you might try is to:
* change the name of the form in your current copy (so you keep it just in
case), and
* import the form from the backup
This way you stand a good chance of solving your problem.

HTH,
Nikos
 
Thanks for this Nikos. Ive managed to find a solution,
although I dont know just why it works. Ive had to remove
the forms query sort and instead introduce some On Got
Focus code to do this. It works but I dont know why my
original design, which works for all other forms, does
not work for this one form. Wierd. Thanks again for
replying, Noel
 
Back
Top