Disable TAB record navigation? (1 Viewer)

S

Stevo3737

New member

Local time

Today, 00:47

Joined

Feb 17, 2010

Messages

9

• Feb 17, 2010

• #1

I have a form which is populated with a record chosen by a combo box. I have set Navigation Buttons to "NO". However, when I TAB through the form and I get past my last button, I am taken to the next record.

Anyway I can stop this? The only way I want someone to be able to switch records is by selecting another value from the combo box.

 

SOS

Registered Lunatic

Local time

Yesterday, 21:47

Joined

Aug 27, 2008

Messages

3,517

• Feb 17, 2010

• #2

Go into the form in design view and change the CYCLE property to CURRENT RECORD.

 

Attachments

• 
  cycle.png

  31.7 KB · Views: 6,058

S

Stevo3737

New member

Local time

Today, 00:47

Joined

Feb 17, 2010

Messages

9

• Feb 17, 2010

• #3

Thanks! That was easy.

 

SOS

Registered Lunatic

Local time

Yesterday, 21:47

Joined

Aug 27, 2008

Messages

3,517

• Feb 17, 2010

• #4

Stevo3737 said:

Thanks! That was easy.

Click to expand...

No problem, glad we could help.

 

Rx_

Nothing In Moderation

Local time

Yesterday, 22:47

Joined

Oct 22, 2009

Messages

2,803

• Apr 26, 2010

• #5

While quickly updating someone else's code, the cycle property worked just perfectlly on a single form when the list box changes focus to a bound text box (and was forcing a new record).

Thought that there might be other answers for this solution and wondered which one best works for a situation.

Another solution posted to prevent the tab forcing the next record was:
Me.AllowAdditions = True/False

Could someone offer some general observations on when to use the Cycle property shown above vs the Me.AllowAdditions ?