Hi!
I have a main form (job)with a subform (object-job)for objects related to jobs - objects are selected from a combo which looks to the main object table. On the subform, I have a button which opens the objects form which opens as a dialog box keeping the focus until it is closed, so that any new objects not listed in the subforms combo can be entered. When I close the object form I return to the subform object-job, and using a requery event on the focus of the object combo, I can now select the new object and relate it to the job.
However, I was wondering is there a way that once I have entered my new object and closed this form, that the object number can be inserted into the subform, as a new record, of the job that I am updating?
I have tried several things, mainly trying to hack the code that enables the value from one form to be pasted into the value of another form, but to no success!
Any help would be very much appreciated (and would speed up my data entry!)
Many thanks
Em
I have a main form (job)with a subform (object-job)for objects related to jobs - objects are selected from a combo which looks to the main object table. On the subform, I have a button which opens the objects form which opens as a dialog box keeping the focus until it is closed, so that any new objects not listed in the subforms combo can be entered. When I close the object form I return to the subform object-job, and using a requery event on the focus of the object combo, I can now select the new object and relate it to the job.
However, I was wondering is there a way that once I have entered my new object and closed this form, that the object number can be inserted into the subform, as a new record, of the job that I am updating?
I have tried several things, mainly trying to hack the code that enables the value from one form to be pasted into the value of another form, but to no success!
Any help would be very much appreciated (and would speed up my data entry!)
Many thanks
Em