Stop from tabbing into a new record

[Epsilon101]

Hi

I have got a couple of problems on the same form. When you tab through the text boxes in the details section of the form, if you have entered information and tab at the end to cycle round it goes to a new record, i dont want it to do this, is there a way to stop it and have it just cycle back to the top of the details of the same record?

Also i have a combo box where you choose the title of a customer ie Mr, Mrs but it also lets you enter your own in the box, i need it so you cant do that but you can choose from the list.

---------------------------------------
Thanks for any help!

 

[jebry]

Hi!

To keep the form from tabbing to a new record go to the property sheet for the form and on the Other tab in the line called Cycle choose Current Record.

To limit the combo box, go to the property sheet for the combo box and on the Data tab set Limit to List to yes.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[paulnnosh]

With your combo box you need to go the data tab of the properties and set the Limit to List property to YES. Make the Row Source Type = Value List and set the Row Source to "Mr";"Mrs";"Miss" (plus any others you want). This will limit users to picking only those values in the list for the combo box.

To tab to the top of the record rather than go to the next record set the Cycle property of your form = Current Record.

 

[Epsilon101]

Thanks a lot for your help, i had just figured it out another problem i am having with the record navigation is the mouse wheel, is there a setting in properties to disable it, or another way to do it.

---------------------------------------
Thanks for any help!

 

[cheesemaster2]

I have a question related to Epsilon's.

I have a continuous subform where each record is nothing more than a text field and a time attached to it. I want the user to be able to add new comments, but I don't want them to tab to it. I created a new record button, but the problem is that whenever the focus is on the last comment, Access will add a new blank record after it. I don't want that blank record to show up unless they click on the button. However, if I set the cycle property to current record, the button doesn't work anymore, it won't allow me to add a new record.

Any suggestions?

-cheese

 

[Epsilon101]

I have a form built now where i have set the cycle property of the form to current record so that the details sections doesnt go to next one on tabbing, i think with yours because its continous the button displays for each record, move it to form footer and use it in there, that way you can lock it when the form is dirty and if they enter something in and dont finish it and then click the button, you can have code to check the required fields have been entered. hope this helps

---------------------------------------
If God is a DJ, Life is the dancefloor, we are the music, then who are the dancers??
.........

Neil

 

[Glacil]

Epsilon101

Regarding the mouse wheel, if you set the Allow Additions and Allow Deletions to No (Making sure to leave Allow Edits set to Yes), the mouse wheel will stop navigating to new records.

This is assuming you aren't going to be doing Additions or Deletions in the subform, of course.

Hope this helps
Evan

 

[Epsilon101]

Cool thanks Evan

---------------------------------------
If God is a DJ, Life is the dancefloor, we are the music, then who are the dancers??
.........

Neil