listbox

  • Thread starter Thread starter pierre
  • Start date Start date
P

pierre

Hi all,

I have a calendar on a form

When the user select a date, i use the on click event of the calendar
to change the controlsource of a listbox with

lstMagno.ControlSource = "SELECT qdfChoixListeExp.NO_INV,
dfChoixListeExp.NoMag, qdfChoixListeExp.DATE_INV " & _
" FROM qdfChoixListeExp WHERE (((qdfChoixListeExp.DATE_INV) = #" &
Forms!frmChoixExport!Cal.value & "#))"

The idea is that the listbox display the data of that day only.

It is not working. Can someone tell me why.

If i put a date directly in the select statement it is working

Looks like the reference to the calendar object is not correct

regards,
pierre
 
Back
Top