mheijligers
New member
- Local time
- Today, 02:42
- Joined
- Nov 15, 2016
- Messages
- 5
[SOLVED] Default value with manual override in case of NULL
Dear all,
I've searched through the forum to find a solution for my problem, but I didn't find an answer yet. So that is why I created a new thread.
I have a single form with several drop combo boxes. My question is about 4 of the combo boxes: Product, Country, Customer and Main customer. Functionality I'm looking for is, when I select a product from the combo box 'Product description', the other 3 combo boxes are filled automatically with the default value from the database table. Data for those 4 combo boxes is stored in 1 table.
Unfortunately, there are a lot of null values in the database table (a product can be available in more than 1 country), so manual override (via row source = "select country from table where id = 1") should be possible. For every combo box there is always 1 value needed. I've tried to implement a dlookup, but then manual override in case of null was not possible. Anybody has an idea how to solve this?
Thanks in advance.
Marc
Dear all,
I've searched through the forum to find a solution for my problem, but I didn't find an answer yet. So that is why I created a new thread.
I have a single form with several drop combo boxes. My question is about 4 of the combo boxes: Product, Country, Customer and Main customer. Functionality I'm looking for is, when I select a product from the combo box 'Product description', the other 3 combo boxes are filled automatically with the default value from the database table. Data for those 4 combo boxes is stored in 1 table.
Unfortunately, there are a lot of null values in the database table (a product can be available in more than 1 country), so manual override (via row source = "select country from table where id = 1") should be possible. For every combo box there is always 1 value needed. I've tried to implement a dlookup, but then manual override in case of null was not possible. Anybody has an idea how to solve this?
Thanks in advance.
Marc
Last edited: