Procedure works Great First Pass, but Not the Second Pass

[quest4]

Good afternoon, I have a form with a subform and in the first txtbox of the subform in the GotFocus event I have a little procedure which checks the txtboxs on the parent to make sure that there is data in all four of the txtboxes. This works great the first time and it pops up a msgbox and it even setsfocus on the txtbox with no data in it, but if I tab into the subform a second time and there still is no data in one of the txtboxs on the parent form, nothing happens, no message and no setting focus on the txtbox with no data in it. Does anyone know of a way to get this procedure to re-set everytime a user tries to enter the subform? Thank you in advance to anyone offering and ideas and suggestions.

 

[KenHigg]

Hum... Could you use the onGotFocus of the subform control itself? (which is on the main form)?

 

[quest4]

The txtbox on the subformis called PartNo and one of the txtboxes I am looking at on the parent form, main form, is called CustomerNo. If when the user tabs into PartNo and CustomerNo on the main form is Null, then I get a message telling me that and I setfocus on CustomerNo on the parent form. That part works great. The problem is that if I don't put any data in the txtbox, CustomerNo, and tab back into PartNo, I don't get any message or sent back to CustomerNo. Do to a little procedure I have it is manitory that I have CustomerNo and PartNo filled inor the procedure will frek out. Any suggestion will be deeply appreciated. Thank you again for the response.

 

[KenHigg]

Hum... I think I would do an OnCurrent event for the main form that sets/resets the sub form text boxes to enabled/disabled based on the main forms textbox

Would that work?

 

[quest4]

I tried it and the same thing happens, first time it works great and the second, no message or anything. It is like it does not reset after it is triggered once. If it was a query, I would just requery the dang thing. Any other thoughts? Thank you again for the help.

 

[KenHigg]

Hum.... Not off the top of my head - Good luck, maybe someone else will give it a stab, I'm fixin' to bug out

 

[quest4]

Thanks, I just discovered this a couple of days ago and I have tried everything that I can think of and nothing has worked yet, it is a real ________.

 

[mresann]

On the subform CONTROL on the main form, put your code in the On Enter event. Remove the code from the text box on the actual subform itself.

 

[quest4]

Thank you for the response. That was interesting, but not good at all. It started going into all the OnCurrent settings I have on the form. These were main the subform settings, if that is important. I use the main forms OnCurrent event to make a lot of things visible and invisible depending on the QCType selected on the main form. You don't happen to have any other ideas do you? thanks you again for the response.