Tab Order sequence Question

[Bolo]

When designing or modifying a form, how do you modify the tab order cycle to
go from the last field in a record to the first field in the next or new
record? I appreciate your help!

Thanks Bolo

 

[Jeff Boyce]

Open the form in design mode. Open the properties. Find the "Cycle"
property. Change it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bolo]

That's too simple!!!!!!

Thanks a lot.

How about this one.

When using the advanced filter and entering the criteria. Let's say I
wanted to look for records that in a field the amount is less than or equal
to six. Okay? So in the criteria box I enter <=6. However, when I apply
the filter. I still get all of them. BUT, if I put 6 in one criteria and 7
as another and 8 as another it works. The six does not have to be in
quotations does it?

Again I appreciate your help!

 

[Jeff Boyce]

<too simple... only if you already know it!>

If you are working directly in the table, consider using a query instead.

What datatype is the field?

What do you get if you put in 6 and 5 and 4...? (<=6)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bolo]

oops I meant >= not < It is supposed to only show 5 & 6 level. The
datatype is a number. I understand query or table, the results are the
same. Should not the >= work?

 

[Jeff Boyce]

I don't use filters much, so I'm not sure if there's a difference (there
shouldn't be, but ... ?!)

Any chance the field is defined as a lookup data type? That could
potentially mess with your filtering/querying.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bolo]

I don't use Access that much either. I have to teach a class this fall, and
this is one of the Objectives of the MOS exam. My students have to take it
at the completion of the class. The book I am using and others I am
referencing show different options for the criteria, but none show use of
these options ( >,<.=) so.......

Well I will keep trying thanks for all your help!