Can't figure this one out

[kingston via AccessMonster.com]

It sounds like you need to change the tab order for the controls. Right
click on the textbox to open its properties window and in the Other tab,
check its Tab Index number. Do the same for the button. To get the focus to
move from the text box to the button, make sure its Tab Index number is one
less than that of the button. You can also control whether hitting enter/tab
moves the focus to a new record or not.

Ok, good news and bad...

Good - Once I did that, the code window poped up and allowed me to
input Me.Requery

I saved it and no error when clicked.

Bad - When I type a name in the box, it doesn't filter the query to
that name only.

I place a name in that box and press return, it moves to the next
record, I place a name in the box and click the button, returns to
record 1.

Any idea what's going on with that? Thanks for all your help,

Byron

When you reach this:

[quoted text clipped - 24 lines]

 

[Dos Equis]

Tabs are set to:

Text box = 0
Button = 1

Enter = default

Same performance.

What next?

It sounds like you need to change the tab order for the controls. Right
click on the textbox to open its properties window and in the Other tab,
check its Tab Index number. Do the same for the button. To get the focus to
move from the text box to the button, make sure its Tab Index number is one
less than that of the button. You can also control whether hitting enter/tab
moves the focus to a new record or not.

Ok, good news and bad...

Good - Once I did that, the code window poped up and allowed me to
input Me.Requery

I saved it and no error when clicked.

Bad - When I type a name in the box, it doesn't filter the query to
that name only.

I place a name in that box and press return, it moves to the next
record, I place a name in the box and click the button, returns to
record 1.

Any idea what's going on with that? Thanks for all your help,

Byron

When you reach this:

[quoted text clipped - 24 lines]

 

[kingston via AccessMonster.com]

Did you place these in the form header and not the detail section? You can
expose the form's header via the View menu in design mode. When you enter a
value in the textbox, the focus should move to the button unless the button's
Tab Stop property is set to No. Otherwise, the only reason why the focus
would move to the next record is if there is code or a macro (either for the
text box or the button) causing it to do so.

Tabs are set to:

Text box = 0
Button = 1

Enter = default

Same performance.

What next?

It sounds like you need to change the tab order for the controls. Right
click on the textbox to open its properties window and in the Other tab,

[quoted text clipped - 30 lines]

 

[Dos Equis]

Both are in the header and both have tab stops. I don't have any
macros built so that shouldn't be a problem and I don't know enough to
code so it may have come from me designing the form, but not sure if it
exists. Should I be looking at something specific?

Byron

Did you place these in the form header and not the detail section? You can
expose the form's header via the View menu in design mode. When you enter a
value in the textbox, the focus should move to the button unless the button's
Tab Stop property is set to No. Otherwise, the only reason why the focus
would move to the next record is if there is code or a macro (either for the
text box or the button) causing it to do so.

Tabs are set to:

Text box = 0
Button = 1

Enter = default

Same performance.

What next?

It sounds like you need to change the tab order for the controls. Right
click on the textbox to open its properties window and in the Other tab,

[quoted text clipped - 30 lines]

 

[kingston via AccessMonster.com]

Sorry, I'm all out of ideas on this one. Try reposting it as a separate
problem. It doesn't make sense to me why the tab order would not be followed
under the conditions you've described.

Both are in the header and both have tab stops. I don't have any
macros built so that shouldn't be a problem and I don't know enough to
code so it may have come from me designing the form, but not sure if it
exists. Should I be looking at something specific?

Byron

Did you place these in the form header and not the detail section? You can
expose the form's header via the View menu in design mode. When you enter a

[quoted text clipped - 23 lines]

 

[Dos Equis]

No problem, you're great for hanging with it as long as you did. Thank
you for all your help, I've actually learned a few things in the
process. something I did want to ask you is in the Me.Requery line,
did I need to, or would it help if I put in the table and field names?
I was playing with it but ran into the query pointing towards the text
box on the table and the etxt box pointing to the query. Doesn't that
create a circlular query?

Byron

Sorry, I'm all out of ideas on this one. Try reposting it as a separate
problem. It doesn't make sense to me why the tab order would not be followed
under the conditions you've described.

Both are in the header and both have tab stops. I don't have any
macros built so that shouldn't be a problem and I don't know enough to
code so it may have come from me designing the form, but not sure if it
exists. Should I be looking at something specific?

Byron

Did you place these in the form header and not the detail section? You can
expose the form's header via the View menu in design mode. When you enter a

[quoted text clipped - 23 lines]

 

[kingston via AccessMonster.com]

Me.Requery is meant to requery the form and its underlying data. The form's
details (data) are based on the value in the text box by way of a query, but
the form doesn't automatically know that the textbox has been modified. Thus,
you created a button to tell the form to requery its underlying data (i.e. re-
run the query based on the new textbox value and re-load the data into the
form's details).

You can use something like Me.Control.Requery when you want a specific
control to be refreshed, but the command doesn't work, AFAIK, with tables and
fields.

No problem, you're great for hanging with it as long as you did. Thank
you for all your help, I've actually learned a few things in the
process. something I did want to ask you is in the Me.Requery line,
did I need to, or would it help if I put in the table and field names?
I was playing with it but ran into the query pointing towards the text
box on the table and the etxt box pointing to the query. Doesn't that
create a circlular query?

Byron

Sorry, I'm all out of ideas on this one. Try reposting it as a separate
problem. It doesn't make sense to me why the tab order would not be followed

[quoted text clipped - 12 lines]