
Form opening not displaying the requested record
We have a strange situation where the user selects a
record in one form, presses a button which opens another
form and forces it to display the selected record for
editing. But, with one particular record, the second form
always displays a different record (always the same one)!
If I step through the code behind the button, I arrive at
the correct record in the second form, but in real time,
it will not display the correct record.
If the second form is already open, the problem is not
exhibited.
Does anyone have any ideas, please?
We have compacted and repaired both the Front-End and Back-
End to remove any corruptions and to rebuild indexes.
The application runs in Office XP (Access 2002 SP1 and
SP2) and under Windows 2000 SP2 and SP3.