Hopefully, someone out there can help as I believe the problem is relatively simple....
On my form, I have a combo box that allows only 2 values (planned & actual). When actual is selected, hidden fields appear; when planned is selected other fields appear. The fields are mutually exclusive and won't appear at the same time.
I have set up filters on the form that help navigate the user to specified data. For example, if a user filters on their name, their records will be filtered. The problem is as a user scrolls through their records, the planned and actual combo will change.
How can I have the appropriate fields (mentioned above) toggle with the record change? I monkeyed around with some of the controls (events) on the form and combo box to no avail...Any ideas?
Thanks
On my form, I have a combo box that allows only 2 values (planned & actual). When actual is selected, hidden fields appear; when planned is selected other fields appear. The fields are mutually exclusive and won't appear at the same time.
I have set up filters on the form that help navigate the user to specified data. For example, if a user filters on their name, their records will be filtered. The problem is as a user scrolls through their records, the planned and actual combo will change.
How can I have the appropriate fields (mentioned above) toggle with the record change? I monkeyed around with some of the controls (events) on the form and combo box to no avail...Any ideas?
Thanks
