moving focus on the subform from the main form

[nndkol]

Merry Christmas to everybody.
I have a main form and a subform, a button on the main form which will act if a condition between 2 controls in the subform satisfies. If the condition does not satisfy the focus will go to one control. I have applied If-Then vba code and setfocus on the subform and thereafter on the control of the subform. But the control could not be found in the program when I run the program. Please suggest or any link where it has already been explained. Thanks a lot.

[gnawoncents]

Please include the names of the form, subform, and controls in question and post the code you are trying to use that is problematic. That way we can better understand what the problem might be and suggest an appropriate fix, example, or tutorial.

[nndkol]

I have 2 tables – “Allotment” & “Release”( both have auto-numbered Primary key as AllotmentID & ReleaseID). The table “Release” has a field with AllotmentID such that every entry in the table “Release” is connected to the table “Allotment". For each AllotmentID there may be many ReleaseID. I have made a main form “frmAllotment” connected with table “Allotment” and a subform “sfrmRelease” connected with table “Release”. The main form has a combo box –“cmbAllotmentID” and one button to exit; the subform has 2 textboxes- txtRelAmt( for [ReleaseAmount] in the table “Release”) and txtApproveAmt( for [ApprovedAmount] in the table “Release”). These are bound form and subform. If I select AllotmentID from the combo box in the main form, the subform will automatically populate data related to that AllotmentID. If there are many records in the subform, I can navigate to the next record in the subform from the built-in navigation button and even create new record with new “ReleaseID” in the subform. The data are autosaved and it works perfectly as per my requirement.
Now I want the condition that txtRelAmt <= txtApproveAmt. The data will not be saved if this condition is not satisfied and the exit button will not allow to exit and the combobox will not allow to select another AllotmentID. And the focus will be on txtRelAmt . But it does not work. Kindly help.

[gnawoncents]

There are a few ways to handle this, but the simplest by far would be to add a validation rule to txtRelAmt. The one below should suffice and will not allow the user to continue until the amount in txtRelAmt is less than or equal to txtApproveAmt.

<=[txtApproveAmt]