>I have a form based on three tables: Customer (obvious), Service (active service records for selected customer), and Parts (parts for selected service record). When the customer picks up the equip., the service record and its parts records are moved to Inactive and InacPart, respectively.
>
>The user wants to be able to switch between viewing active and inactive service records. To accomplish the switch (without having two copies of the same form), I do the following:
>
>SELECT Service
>USE Inactive ALIAS Service
>SELECT Parts
>USE InacPart ALIAS Parts
>
>After re-establishing the relationships, everything works great except for the grid showing the parts: it disappears completely. No columns, no rows, just a white rectangle where the grid used to appear. Can this be fixed, or am I forced to live with the overhead of two forms?
>
Not exactly sure what you're doing, but...
Sounds like the grid lost its source...you may need to set the recordsource = '' and the reset it to parts after your changes.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.