input data - no duplicates

A

av

Hi,

I would like to keep track of money cheques with their status w/ due dates.

Every cheque has it's unique serial no and it is posible to select one via
combo box - the particular one (cheque) - but no more than once (of course).

Is it possible for the combo box to reduce data offering (in combo) as you
progress with input?
( It sould not offer already selected cheques but exclude them from the list
and offer in combo only those not yet spent )



Any idea?
Thx.
 
A

Al Camp

What, in the Check record indicates that it has been selected... or
spent?

If you are unable to determine that, or you have no way of determining
that, then the combo will not be able to determine that either.
You'll have to add a field to your table that will store the Selected/Not
Selected condition... or Spent/NotSpent. Like a check box... then the combo
query (Row Source) can filter those out.
Also, you'll have to requery the combo after a check has been marked
Spent... if you are moving through several selections in a row.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Top