T
tom
I have a list box on a form based on an SQL query.
The query relies on dates that are input into the form.
The list fields include the invoice number, Company
name, extension, etc. I want to double click on an
entry in the list and open another form using the
invoice number as criteria.
I have used various permutations of the following in
the where condition of the macro but I cannot get it
to work.
[number]=[Forms]![InvoiceForm]![MarginsNameOfListBOX]![Invoice number]
The query relies on dates that are input into the form.
The list fields include the invoice number, Company
name, extension, etc. I want to double click on an
entry in the list and open another form using the
invoice number as criteria.
I have used various permutations of the following in
the where condition of the macro but I cannot get it
to work.
[number]=[Forms]![InvoiceForm]![MarginsNameOfListBOX]![Invoice number]