Multiple text boxes with same VB functionality

[EddiRae]

Hello,
I have a form that has a layout like a spreadsheet to be used for scheduling patients.
I have the text boxes on the top to be the interns, the text boxes on the left to be the time slots and what is in the middle are the patients.

When you click on a text box in the middle, you get sent to another form that lets you select the patient and enter other information for the appointment. This form then closes and the main schedule form refreshes with the new information.

I have individual text boxes for the middle. Is there a way to have only ONE subroutine that will work for all the ON CLICKs of the text boxes? I am trying to have 15 * 41 (615) entries of the same code.

Thank you for your help!1
Eddi Rae

 

[CEH]

Look into using the "Tag" property on each control. Then you could run an "If....Then" statement to requery on controls with tags.

 

[Uncle Gizmo]

You may find this thread useful..

Handling Multiple Controls

 

[Uncle Gizmo]

Also this thread:

Lock UnLock Controls The thread includes video instructions as well and covers some advanced programming techniques which I hardly understand my self...

 

[EddiRae]

Is this going to work with the OnClick Event?

 

[Banana]

A technique that will work not only for OnClick event but also any other events

Soft-coding event handlers

 

[Uncle Gizmo]

>>>>Is this going to work with the OnClick Event?<<<

I'm not sure who you are asking, and I'm not really sure what you are asking please could you rephrase your question?

 

[Uncle Gizmo]

A technique that will work not only for OnClick event but also any other events

Soft-coding event handlers

Very Nice.....


I was going to add to your "reputation" but the damned machine won't let me.

 

[Banana]

Don't thank me. Thank ChrisO.

 

[EddiRae]

Thanks Banana!!!

That is what I was looking for!!

Eddi Rae

 

[Uncle Gizmo]

Don't thank me. Thank ChrisO.

Done..................