Pangloss14
Registered User.
- Local time
- Today, 09:51
- Joined
- May 30, 2003
- Messages
- 19
Hi,
Table 1: ID (Primary key), a bunch of other stuff.
Table 2: ID, Test, Result. Primary key is combination of ID and Test.
What I want to do is have a form to input the various test results using option groups for the input. For simplicity, let's assume for now that the number of tests is always the same. I have come up with a couple of solutions and was wondering if anyone had a better idea.
1. Form with subform, with ID on one level, and the Test and Result on another. Bind the control for option group to Result. This works fine except that I think I'm limited in how I can format it (everything is row by row, even spaces). Also, I can't seem to get rid of the the blank test (i.e. I have 7 tests, but the blank for #8 always shows up for the option group).
2. One form that uses Table 1 as it's source. Create labels for each test, and have unbound option groups. Populate these option groups with VBA code. This works as well, it just seems like overkill (and I presume slower as well).
3. I suppose that the control source of each option group could be a query. I could write a separate query for each test and plug it into the control source. I'm sure there's a better way of doing this (have query accept a value, is this possible from with the control source field?).
Any input would be appreciated. I don't suppose that the expression builder is any help here...
Thanks.
Table 1: ID (Primary key), a bunch of other stuff.
Table 2: ID, Test, Result. Primary key is combination of ID and Test.
What I want to do is have a form to input the various test results using option groups for the input. For simplicity, let's assume for now that the number of tests is always the same. I have come up with a couple of solutions and was wondering if anyone had a better idea.
1. Form with subform, with ID on one level, and the Test and Result on another. Bind the control for option group to Result. This works fine except that I think I'm limited in how I can format it (everything is row by row, even spaces). Also, I can't seem to get rid of the the blank test (i.e. I have 7 tests, but the blank for #8 always shows up for the option group).
2. One form that uses Table 1 as it's source. Create labels for each test, and have unbound option groups. Populate these option groups with VBA code. This works as well, it just seems like overkill (and I presume slower as well).
3. I suppose that the control source of each option group could be a query. I could write a separate query for each test and plug it into the control source. I'm sure there's a better way of doing this (have query accept a value, is this possible from with the control source field?).
Any input would be appreciated. I don't suppose that the expression builder is any help here...
Thanks.
Last edited:
