Filters on a form 3

[JamesLynch]

I have a table with 100 records with eight fields in each.
A form that displays two tick boxes.
- Checked (y/n)
- Succesful (y/n)

I need the end user to select to check through these records and tick them off, if a similar record is found from a diffenent source.

So far, so good.

However I only want those records that have yet to be ticked, to be visible to the end user. Therefore they won't need to constantly check a record that has already been succesfully reviewed.

 

[TorF]

Why don't you add 2 fields into your table source ? => Checked and Succesfull as boolean

Then add a filter like "Checked = false"

 

[rkdcomp]

Why don't you open your records via a QUERY where in the Fields

- Checked (y/n)
- Succesful (y/n)

set the Critera to 0 (that's a ZERO) for a NO and only the records that have not been checked will show up.

Note, a -1 is equal to a YES.

Hope this helps.

Richard in Tulsa.

 

[gusbrunston]

[tt]
And, you could base your form on a query that selects only the "unticked" records, with a paramater set to "False". Gus Brunston An old PICKer, using Access2000

Intermediate skills. Back up before taking my suggestions!

 

[gusbrunston]

[tt]
Richard, I seem to be following you around. I'm going to brunch.

Cheers, Gus Brunston An old PICKer, using Access2000

Intermediate skills. Back up before taking my suggestions!