Dear MacDonald,
Tanks very much... simply but is what i need
User Profile
Collapse
-
Manage toolbox created at runtime
Hi to all,
i just made an form where with button add 10 textbox whith this code:
...Code:For X = 1 To 10 Me.Controls.Add(tx) tx.Visible = True tx.Width = 300 tx.Name = "TxtBox" & X tx.Text = tx.Name '"testo che appare nella box" & X tx.Location = New Point(300, 30 * X) -
use for each in subform
Hi to group
I have an form(form0) with 2 subforms(form1 & form2), with VBA, apply filter to form1.
Now I tried update second form with filtered data of form1 with this code:
...Code:For Each field1 In Forms!form0.Form!form1.Form sqlstr = "UPDATE Forms!form0.Form!form2.Form SET Forms!form0.Form!form2.Form!fieldWW = forms!form0.form!form1.form!field1 where ........ DoCmd.RunSQL sqlstr
Last edited by TheSmileyCoder; Apr 22 '11, 07:01 PM. Reason: Remember to put square brackets around the [code] tags.
No activity results to display
Show More
Leave a comment: