OK, here is my problem:
I have 2 tables:
Tests
-TestID (Autonumber)
-TestDesc (Text)
TestInput
- TestInputID
- TestID
- InputDesc
Now, in my CONTINUOUS form I have 2 combo boxes:
The first one uses the tables TESTS as the rowsource.
In the second one I want to display only the TestInput values that are valid for that TestID.
I have tried the following:
- In the AfterUpdate event for the TESTS combo, I reset the rowsource for the TestInput combo.
What happens is that this updates the RowSource for that field in every record in the form. Since different records have different TESTS combo values, in NON-CURRENT records, the TestInput combo goes blank when the TestInput ID is not valid for the CURRENT record TestID.
I tried doing the same update in the OnEnter event for the TestInput combo. That way when you click on a combo that "appears" blank but really isn't the valid data appears.
Is there any way to set the combo box rowsource or other property in such a way that other records are not affected?
Any help is appreciated
Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt
I have 2 tables:
Tests
-TestID (Autonumber)
-TestDesc (Text)
TestInput
- TestInputID
- TestID
- InputDesc
Now, in my CONTINUOUS form I have 2 combo boxes:
The first one uses the tables TESTS as the rowsource.
In the second one I want to display only the TestInput values that are valid for that TestID.
I have tried the following:
- In the AfterUpdate event for the TESTS combo, I reset the rowsource for the TestInput combo.
What happens is that this updates the RowSource for that field in every record in the form. Since different records have different TESTS combo values, in NON-CURRENT records, the TestInput combo goes blank when the TestInput ID is not valid for the CURRENT record TestID.
I tried doing the same update in the OnEnter event for the TestInput combo. That way when you click on a combo that "appears" blank but really isn't the valid data appears.
Is there any way to set the combo box rowsource or other property in such a way that other records are not affected?
Any help is appreciated
Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt