T
Tony Kuiper
I have two combo boxes and two list boxes on a form.
Each combo box has a RefreshPage Macro run command on it.
I have an query linked to each list box that uses the combo box data as a
filter to return the correct value to the list box.
After selecting an item in the first combo box the value in the first list
box updates, BUT, when I select the value from the second combo box the first
LIST BOX goes blank when the form refreshes.
Is there a way to get this result without using the RefreshPage command? I
would prefer to have the list boxes being text boxes.
Secondly when I try to write the data from the form into a table using the
INSERT INTO SQL function it wont write to the table despite all of the values
in the SQL statement having valid values against them. I have checked and
rechecked the table column data types to ensure they match. Each table field
can even be NULL or ALLOW BLANK etc so even the form being blank should
insert something surely?
Each combo box has a RefreshPage Macro run command on it.
I have an query linked to each list box that uses the combo box data as a
filter to return the correct value to the list box.
After selecting an item in the first combo box the value in the first list
box updates, BUT, when I select the value from the second combo box the first
LIST BOX goes blank when the form refreshes.
Is there a way to get this result without using the RefreshPage command? I
would prefer to have the list boxes being text boxes.
Secondly when I try to write the data from the form into a table using the
INSERT INTO SQL function it wont write to the table despite all of the values
in the SQL statement having valid values against them. I have checked and
rechecked the table column data types to ensure they match. Each table field
can even be NULL or ALLOW BLANK etc so even the form being blank should
insert something surely?