find next and checkbox

[Certified]

I have a form with about 1000 records.

I have it set up so if the data in certain form fields meets a criteria, a checkbox is Checked (true).

The checkbox lets the user know they must enter additional data.

The issue is each user has to scroll through each record to find the ones that are checked.

Is there a way I can goto the records that are only checked?

I am familiar with VBA code for excel but not for Access.

 

[Joe4]

Just create a query with criteria that only return the record where this field is checked (true).
Then base your form on that query.

 

[Certified]

The checkboxes are only on the form.

Just create a query with criteria that only return the record where this field is checked (true).
Then base your form on that query.

 

[Joe4]

How are they calculated?

Note, if it is not stored anywhere, I don't know that you are going to be able to easily go to records that are checked, aince they aren't calculated/checked until you actually go to the record and perform the calculation.

I would recommend doing the calculation in the query, so it will be checked there at that level.

 

[Certified]

The checkboxes are calculated on the form.

I don't think a query would work because I have more than one checkbox. For instance, the checkbox is like a tag. One record can have more than one tag or Category. Does that make sense?

is

How are they calculated?

Note, if it is not stored anywhere, I don't know that you are going to be able to easily go to records that are checked, aince they aren't calculated/checked until you actually go to the record and perform the calculation.

I would recommend doing the calculation in the query, so it will be checked there at that level.

 

[xenou]

Whatever creates the logic that says "this is checked", then use the same logic in your query...

 

[Certified]

Thanks Xenou. I tried that and It worked.

 

[Joe4]

Thanks Xenou. I tried that and It worked.

That is what I had recommended earlier, up in post #4.

I would recommend doing the calculation in the query, so it will be checked there at that level.

 

[Certified]

You are right! Thank you too!

That is what I had recommended earlier, up in post #4.