Search results for query: *

MajP, I really appreciate your help -- I have not had a chance to get back to the project, but will tommorow and will try your suggestions, and am grateful for your help Steve

Hi MajP Yes I want to open an existing record on subform2 as selected by the criteria (JobID) on subform1. Both forms have the same single table as their source. Here is the code that I try to execute upon the click event on subform1. Private Sub TS4Name_Click() Dim thisjob As String...

Majp Still not quite what I need . There are two subforms on the Parent, the first and the second - I would like to update the record in the second subform area with a record selected by using criteria from a control on the first subform . The process would be initiated by using a click event...

Majp Sorry, I should have been more clear I have the second subform already on the Parent along with the first - I would like to update the record in the second subform area with a record selected by using the data from a control on the first subform . The process would be initiated by using a...

Majp I have the second subform already on the Parent along with the first - I would like to just update the data in the second subform area with data selected from the first subform area. thanks,Steve

HI PH After the parent form is opened, I want to open the second subform with a record where the criteria for the second record is contained in the first subform Thanks, Steve

PH I have tried your suggestion, but it results only in the opening of a second frmControlDispatch which is isolated from the Main form and does not affect the subform results

I can not open a second subform from a first subform on the same parent - I am using the following procedure that is called from a double click event on the first subform Public Sub OpenScheduleDetails(passedJobID As Variant) Dim JID As String JID = passedJobID DoCmd.OpenForm...

I can not open a second subform from a first subform using Public Sub OpenScheduleDetails(passedJobID As Variant) Dim JID As String JID = passedJobID DoCmd.OpenForm "forms![frmMS]![frmControlDispatch]", , , "JobID = " & JID End Sub Where the parent form is frmMS and the subform I wish...