>>>I have created many one-to-many forms without problems. Suddenly, I have one that WILL NOT WORK:
>>>
>>>I have a combo box whose RecordSource is a field from the parent table (committee names). The grid should show members of the selected committees. The InteractiveChange SEEK's the DisplayValue of the combo box in the parent table successfully. However, the grid remains empty. I have the relationship established in the Data Environ., all properties in the grid data tab filled in correctly (checked them 50 times at least). Have hand-filled the data tab properties and let the grid builder do it for me. Have yet to see a single committee member in the grid, even when I first enter the form. When I view the databases from within the form, the relationship shows properly. When I select another committee, the relationship shows properly. Any ideas out there??
>>>
>>>TIA.
>>
>>Well, it shurely sounds stupid but before i went on holidays last week, it happened exactly the same to me. Altough I haven't changed anything it worked perfect today...
>>Don't ask why but I'm starting to believe that computers have a soul! Maybe you should give him a week holidays... :-)
>
>Alexandre:
>
>Unfortunately, I've been at this problem for about four days. If this thing doesn't work soon, I'm going to give it a memorial service! <g>
>
Probably this is not relevant, but it's true that the Displayvalue is not extremely reliable. Value is safer...