Combo Box

M

Meri

Can anyone help me out?

I successfully retrieve a form's record via a combo box.
For a given client my cbo returns date and invoice
fields. Presently, the cbo is bound to column 1 (invoice
#) with date in column 2. The recordsource query has, of
course, columns reflecting the above in descending order
(each). See the criteria I have in client field below.

I need to list in date order and date is not exclusive;
invoice number is.

What I have tried is changing columns 1 and 2 and binding
my cbo to column 2 invoice date. Works fine except when
closing the form, its looking for "[frmWork]![ClientID]".


My query has in the client field's criteria:

IIf(IsNull([Forms]![frmWork]![ClientID]),[tbl2Work]!
[ClientID],[Forms]![frmWork]![ClientID]) Or IIf(IsNull
([Forms]![frmWork]![ClientID]),[tbl2Work]![ClientID],
[Forms]![frmWork]![ClientID])


Anyone? Thanks in advance.

Meri
 
Top