T
ted medin
We have an unbound form & would like to load the text box on the form with
data, then wait for the operator to make changes on the form. After that we
would like to get the data from the text box & proceed with the vb code.
Here is a skeleton of the vb code.
DoCmd.Openform "test form", acPreview, , , acFormEdit, acWindowNormal
Forms![test form]![MEM#] = 345
DoCmd.Openform "test form", , , , WindowMode:=acDialog ' wait for the
ok
strtemp = forms![test form]![mem#]
DoCmd.Close acForm, "test form", acSaveNo
Tried to do it without the first docmd.openform but no banana. Any ideas?
TIA
data, then wait for the operator to make changes on the form. After that we
would like to get the data from the text box & proceed with the vb code.
Here is a skeleton of the vb code.
DoCmd.Openform "test form", acPreview, , , acFormEdit, acWindowNormal
Forms![test form]![MEM#] = 345
DoCmd.Openform "test form", , , , WindowMode:=acDialog ' wait for the
ok
strtemp = forms![test form]![mem#]
DoCmd.Close acForm, "test form", acSaveNo
Tried to do it without the first docmd.openform but no banana. Any ideas?
TIA