Autofill in Subform

[cbearden]

I have a Subform on my form. I am trying to get it to be filled in when someone does the following:
Enters number into txtNum and then clicks on the OK cmd button.

The form is based on a table called Cancel. The subform is based on a tabled called Deal
The controls on the subform are as follows:

intNum
txtName
txtContact
txtPhone
txtFax
dtmUpdated

Also, the intNum cannot be duplicated in the Deal table.
The field that links the tables, Cancel and Deal, is intNum.

Thanks for the help.