Changing Tools->Options behavior at run-time

[KarstenTech]

I have a multiform app. On one form I want the enter key to move to the next field, on another I want it to move to the next record. I see that I can set this behavior under Tools-Options, but that then sets the behavior for all forms. Any ideas?

Thanks

 

[Marshall Barton]

I have a multiform app. On one form I want the enter key
to move to the next field, on another I want it to move to
the next record. I see that I can set this behavior unde
Tools-Options, but that then sets the behavior for all forms.

I'm not sure what you want here. Maybe you want the form's
Cycle property?

Or maybe you want to create a miniscule button with its
Dafault property set to Yes. The button can the navigate to
any record.

OTOH, maybe you can get away with using the PgDn key to move
to the next record?

 

[KarstenTech]

I'm sorry if this is a dup responce, I don't see my earlier one.

Marshall, thanks for your reply. The Cycle property of a form isn't going to work for me.

I have two forms with subforms (think an Order and it's associated line items)

On one form when the user presses the enter key, I want to move the cursor to the next field of that item.

On another form when the user presses the entery key, I want to stay in the current column (think ... quantity) put move down to the next order item.

I can change this behavoir globally using the Tools->Option dialog. What I am looking for is a way to change this behavior dynamically at run-time. Possibly using the DoCmd call.

Any Ideas?

Thanks

 

[JohnFol]

There are several ways of doing this, but you could just use the appropriate
one of the following when the form loads . .
Try

Application.SetOption "Move After Enter", 0

Application.SetOption "Move After Enter", 1

Application.SetOption "Move After Enter", 2

I have a multiform app. On one form I want the enter key to move to the

next field, on another I want it to move to the next record. I see that I
can set this behavior under Tools-Options, but that then sets the behavior
for all forms. Any ideas?