Listbox Selection

[Asif]

I have a form with a List Box(lst_entry), upon clicking on an entry a
new form (frm_edit) should load up showing the details of the entry
selected in listbox.

In the "On Dbl Click" event I've used the following code;

Private Sub Lst_entry_DblClick(cancel As Integer)
DoCmd.OpenForm "frm_edit", , , "BINPROCESSID = " & List23.Column(0) &
" and BINPROCESSDate = " & List23.Column(1)
End Sub

However I'm getting the following error message every time I dbl click
on an item in the list;

Run-time error '3075': Syntax error (missing operator) in query
expression 'BINPROCESSID = 43 and BINPROCESSDate=16/03/07 15:11:06',

Any ideas what I'm doing wrong??

Thanks

 

[Brendan Reynolds]

You need '#' symbols around the date, e.g. = #" & List23.Column(1) & "#".

You might also want to check out what Allen Browne says about handling date
formats at the following URL ...

http://allenbrowne.com/ser-36.html