Weird tab order and query issues - Please help

[Irina]

I got 2 questions
1) Tab order in a form
My form has 6 fields that user can either type in info or
select from the list.
The tab order I want is from field 1 go to 2, 3, etc
what it does now is when the fields are blank the tab order is fine, but
when I type in info, the tab order becomes weird: it jumps back to the first
field after every next one: like 1, then 2, then 1, then 2, 3, then 1, 2,3,4,
then 1,2,3,4,5 - is that clear what it does?
why is the form doing that????
2) I have a query that selects a last name
-like tbl.Individual &"*" per user input
what it does is finds all records for "Hu" but also for "Hugh" and "Hugher"
- I want to just select exact string match but the Individual field is
actually LastName, FirstName format. Is there a way to accomplish what I
want??
thanks for your help (anyone)

 

[Jeff Boyce]

Irina

I haven't run across a tab order that changes before, so I can't help on
that one.

If you use a query to concatenate LastName & Firstname, and use that query
as a source for a combobox, your users can select the name/person they are
after (unless, of course, your list of people includes folks with exactly
the same name!).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[AY]

Try using View/Tab orders... to set the prefered sequence.

 

[Al Campagna]

Irina,
In addition to the other suggestions... any chance these fields are on a
Tab control.
If they are, then their tab order can only be set up properly when the
individual tab page the controls reside on, is selected... not while the
main form or it's controls are selected.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Irina]

The tab order is set in that particular form.
The only time when it is not working is when i fill in text, it
jumps back to the first field instead of going to the next.
DO you have any other ideas?