Hi everyone
I have a form that contains a list box with the row source = a query between two tables and various text boxes bound to each column in the list box. I've introduced a 3rd table with three columns (2 date/time and 1 combo box data types). I've edited the query to include these 3 new columns but what I'm trying to do is make them appear on the form. My question is, is there a max amount of columns that can appear in the list box? So far there is 9 and even with the edited query the new columns don't appear on the list box. Once they become visible, I can set the text box as "=[listBoxName].Column(9)". Any feedback is much appreciated!
I have a form that contains a list box with the row source = a query between two tables and various text boxes bound to each column in the list box. I've introduced a 3rd table with three columns (2 date/time and 1 combo box data types). I've edited the query to include these 3 new columns but what I'm trying to do is make them appear on the form. My question is, is there a max amount of columns that can appear in the list box? So far there is 9 and even with the edited query the new columns don't appear on the list box. Once they become visible, I can set the text box as "=[listBoxName].Column(9)". Any feedback is much appreciated!