Arthur Fuller
fuller.artful at gmail.com
Sun Oct 9 14:43:06 CDT 2011
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