code for skipping record if a condition isn't met

S

SAC

I'd like to skip a record on a report if a condition isn't met.

Something like:

If txtCode < "B" then skip record.

Thanks.
 
F

fredg

SAC said:
I'd like to skip a record on a report if a condition isn't met.

Something like:

If txtCode < "B" then skip record.

Thanks.
Click to expand...

Not sure what you're looking for here.

Skip the record or skip the field?
Do you mean something like not showing a field in the report?
In the Detail Format event:

txtCode.Visible = txtCode >= "B"

Or moving completely to the next record?
Look up:

NextRecord
MoveLayout
PrintSection

in VBA help.
Open any code window and click help.
 
F

Fons Ponsioen

I think you are looking skipping a record in a report.
The symplest way would be to base the report on a query
rahter than a table. In the query you can tell it in the
criteria specify < "B"
Hope this helps.
Fons
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning 1 of 4 values if conditions are met 4
Force skip to new page? 2
Sequential numbering records (skipping some records) 1
Prevent skip to new page after last page prints 3
How conditionally skip stuff on a report? 31
Skipping page conditionally 3
skip to next from if 0
Skip a record in code? 1

Top