Command button On Form

[TheGeneral]

Hi, I have an unbound text box called "EnterJobID" and this is on my form FRM_JOB_SWITCH and in my unbound text box I want to be able to type a Job ID and then click the button next to the text box which opens that specific Job ID Record in Form View.

Any help would be appreciated please. I like tothink it is a simple command within the macro builder WHERE condition but everything I have tried has failed so far.

Thanks in advance for any help.

 

[pbaldy]

Does this help?

http://www.baldyweb.com/wherecondition.htm

 

[tobyjenkins]

Is the second form bound?