Referencing Table Field as Variant Acc2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've got an unbound listbox named "CC" whose Row Source is dependent upon
the current form's (fname = EXCEPTION) "DEPT" field value. For example, if
DEPT = 'Operations' then the Row Source = 'Operations' which corresponds to
an underlying "CC" table field name. There will be occasions when a DEPT
value will not match the CC table field name.

I'm looking for a way to have the dbase pass over any non-matching values
without a query parameter or error message popping up. My code is within the
Form's On Current event procedure. (Access 2002)
Thanks
 
Gwhit said:
Hi,
I've got an unbound listbox named "CC" whose Row Source is dependent upon
the current form's (fname = EXCEPTION) "DEPT" field value. For example, if
DEPT = 'Operations' then the Row Source = 'Operations' which corresponds to
an underlying "CC" table field name. There will be occasions when a DEPT
value will not match the CC table field name.

I'm looking for a way to have the dbase pass over any non-matching values
without a query parameter or error message popping up. My code is within the
Form's On Current event procedure. (Access 2002)
Thanks
Click to expand...

Please post the listbox row source statement/SQL and the code in the form
current event procedure.
 
Back
Top