command button default property

[roh_8_it_3]

hi all,

i am trying to find a solution for this.I have a continous form which displays records..for every record there is a command button which opens the other screen for that particular record.

when ever i hits the enter key the command button opens the another form for the 1st record in the continous form.I want to disable this.

i set the default property to no but it not working .I also tried to to do it by vb code like

cmd.default=False

on the page load but it still not working.

any solution for this pls.

thanks

 

[Crispy]

Instead of having the command button you could show resord selectors on your subform, then enter the code in the OnClick event of the subform.

 

[Crispy]

Instead of having the command button you could show resord selectors on your subform, then enter the code in the OnClick event of the subform. Then the user could click on the record selector to navigate to the main form.

 

[roh_8_it_3]

that works wine .I am using the record selectors and on the click event of the details i m opening the other form.but i have to click on the record in the continous form and clicking on the record selector doesnt work.



But when you click on the command button it shows the hour glass..how cani show it now??

Also i still dont know what was wrong if i was using the command button??

thanks for ur help.

 

[quest4]

I have opened another form to the record I was working on in the original form. I used this procedure in the cmdButtons OnClick event:
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "YourFormName"

stLinkCriteria = "[Pkey]=" & Me![Pkey]
DoCmd.OpenForm stDocName, , , stLinkCriteria
This works pretty well for me, the new form opens up to the same record I am on in this form. hth.

 

[roh_8_it_3]

hi quest,

i am also using the same code on the command button and it works fine.

The only problem is the default behavior of the command button when it opens the another form on hitting the enter key.

I tried to disable it explaining it in my first form.Any idea on how can i disable it??

thanks

 

[quest4]

Default Behavior? There is no default on a cmdButton. As long as you comment out or delete al previous code, except the first and last line, only that code will run. Now is you have other procedures and modules, they could be affecting the code you just added. Try running C&R, hopefully that will clean up things. If problem still exists, it is the debug time. Open the procedure in question and someplace near the top of the procedure add a new line:
Stop
Save and close. Then try to click the cmdButton and the VB editor should open and the Stop hi-lited. Then F8 you way though the code you should then be able to at least see where this code is going from step to step. You will probably be surprised at where this thing goes. hth.

 

[roh_8_it_3]

see the other tab on the properties window.I know how to debug code but i dont know how can i disable that default behavior of command button.

there is no problem with the code.it opens the new form .its just i dont want to open the new form on hitting the enter key.

any ideas??

 

[quest4]

The only way I know of to disable code is to comment it out. Just pu a ' at the beginning of the line. hth.

 

[roh_8_it_3]

thanks..i know how to comment code.

 

[quest4]

Around here you can never be to sure on how much a person knows. Good luck.