Hey, basically what i have got here is a list box with a single number in it which changes depending on the value of several combo boxes. I want to create a table which inserts this number, when i click a submit button. Now everything works fine here like the list box updating depending on the combo boxes, however when i click the submit button it says that is can not convert the value from the list box.
The way i have tried to implement this is by using RunSql
on the button_clicked and using:
insert into table values(listbox,idno);
The idno is trivial and inserts into the table fine as it is from a textbox, however access doesnt seem to be able to convert the value in the list box to a text value in a field.????
The way i have tried to implement this is by using RunSql
on the button_clicked and using:
insert into table values(listbox,idno);
The idno is trivial and inserts into the table fine as it is from a textbox, however access doesnt seem to be able to convert the value in the list box to a text value in a field.????
