frostysnoman
New member
- Local time
- Yesterday, 21:13
- Joined
- Oct 11, 2004
- Messages
- 6
Hi everyone,
Wondering if anyone wanted to help an idiot. I have a form that first asks the user to select a country ( derived from a table of countries). There are two other comboboxes that have a population based on the country. I have tried everything from onclick update, on update update, onchange update. But when the country gets changed, the two comboboxes don't change until you look at the RowSource. I saw an example of combo boxes that filtered on top of each other, but it was all derived from the same table. Is that the key? Please help, I have been working on this for a while, and am getting upset. ( I guess it is about time for a new computer, so running this one over with the car would be a good step).
SELECT [All USAID Programs].ID, [All USAID Programs].Program
FROM [All USAID Programs]
WHERE ((([All USAID Programs].Country)=[Forms]![Form2]![Text6]));
is the row source that seems to work, only not update the information based on the change in text6 ( unless you look at the row source).
Wondering if anyone wanted to help an idiot. I have a form that first asks the user to select a country ( derived from a table of countries). There are two other comboboxes that have a population based on the country. I have tried everything from onclick update, on update update, onchange update. But when the country gets changed, the two comboboxes don't change until you look at the RowSource. I saw an example of combo boxes that filtered on top of each other, but it was all derived from the same table. Is that the key? Please help, I have been working on this for a while, and am getting upset. ( I guess it is about time for a new computer, so running this one over with the car would be a good step).
SELECT [All USAID Programs].ID, [All USAID Programs].Program
FROM [All USAID Programs]
WHERE ((([All USAID Programs].Country)=[Forms]![Form2]![Text6]));
is the row source that seems to work, only not update the information based on the change in text6 ( unless you look at the row source).
