UNBOUND to button command

RINGO STARR · April 14th, 2011, 03:16 AM

I have this "unbound command" and "Button Command"

In Unbound command - its for ID Number only.

Would it be possible if i click the particular number then it would search to "Button command"? and it will appear all the details which you have searched from "unbound command"?

Please help thanks.

gjgriffith · April 14th, 2011, 04:22 AM

Hello Ringo,

Thanks for the note, I saw your post here, but I'm a little confused. You said:

Quote:

I have this "unbound command" and "Button Command". In Unbound command - its for ID Number only.

When you are referring to an "Unbound Command", it sounds like you are referring to an "Unbound TextBox" control, is that correct? If so, could you use the "Click()" event for the TextBox to call the "SetFocus()" method for the button, to move focus to the button. For example, here is some code to do that:

Code:

Private Sub Text2_Click()

    ' Set focus to a button control
    Me.Command4.SetFocus

End Sub

Otherwise, you could write whatever code behind the TextBox Click() event to do whatever search you need! Does this make sense and/or help? Please let me know if you still have questions!

HiTechCoach · April 14th, 2011, 10:44 AM

Also check out he combo box control wizard. It has an option to create a combo box for finding a record. You can look at eh VBA code it creates to learn how to find a record based on an unbound control..

RINGO STARR · April 16th, 2011, 10:43 AM

Quote:

Originally Posted by gjgriffith

Hello Ringo,

Thanks for the note, I saw your post here, but I'm a little confused. You said:

When you are referring to an "Unbound Command", it sounds like you are referring to an "Unbound TextBox" control, is that correct? If so, could you use the "Click()" event for the TextBox to call the "SetFocus()" method for the button, to move focus to the button. For example, here is some code to do that:

Code:

Private Sub Text2_Click()

    ' Set focus to a button control
    Me.Command4.SetFocus

End Sub

Otherwise, you could write whatever code behind the TextBox Click() event to do whatever search you need! Does this make sense and/or help? Please let me know if you still have questions!

Thanks Sir Gj,

Please click the utube link below.. i want to make unbound similar to this command. that if you click the "Payroll ID" first then second you will click the Personal details it will come up with particular personal details of the screen based on the Payroll ID that you click. I like this presentation in utube and i want to make similar on this but i dont know some of the command. Hope you can help me thank you so much in advance

thanks

http://www.youtube.com/watch?v=_qc0l...eature=related