hallo there ...
I have a form called booking .
in there there is a combobox with 2 column !
film_ref , Film_Title
and then I have a listbox in the same form
in the rowsource of the listbox I have :
SELECT tblShow.SHOW_DATE, tblShow.SHOW_TIME, * FROM tblShow WHERE (((tblShow.FILM_REF)=me!combo0.column(0)));
it would then complain about the me!combo0.column(0)
why is that ? Am I using it in the wrong way ?
I have a form called booking .
in there there is a combobox with 2 column !
film_ref , Film_Title
and then I have a listbox in the same form
in the rowsource of the listbox I have :
SELECT tblShow.SHOW_DATE, tblShow.SHOW_TIME, * FROM tblShow WHERE (((tblShow.FILM_REF)=me!combo0.column(0)));
it would then complain about the me!combo0.column(0)
why is that ? Am I using it in the wrong way ?