Stuart McLachlan
stuart at lexacorp.com.pg
Sun Oct 9 16:59:04 CDT 2011
Forms("FormB).Form!MachineOrPress -- Stuart On 9 Oct 2011 at 15:43, Arthur Fuller wrote: > I'm having trouble with the following scenario: > > I'm in one form (call it FormA). A button there opens another form > (FormB), which displays a list of records and a pair of buttons (Copy > and Close). The code in FormA opens FormB in dialog mode. The general > idea here is that the user selects a record on FormB and hits the Copy > button, whose code merely says "Me.Visible" = False. The code on the > Close button closes the form. At this point, we are back on FormA, If > FormB is still loaded, then I want to copy certain of its controls to > controls of the same name on FormB. > > I've tried several approaches such as: > > With Me > .MachineOrPress = Forms("FormB).MachineOrPress > End With > > I also tried; > > Dim frm as form > Set frm = Forms("FormB") > With Me > .MachineOrPress = frm.MachineOrPress > End With > > In both cases, all I can see in Intellisense is the properties of > FormB -- not the list of controls. > > I know there has to be a simple way to to refer to FormB's controls, > but so far I haven't got it, and if I don't it soon I'll scrap this > approach and use a recordset instead. > > Can anyone help me sort this out? > > TIA, > Arthur > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >