Re: GUI for access 2002

It seemed so clear to me :-). Sorry here are some pertinent parts of the
code:

with rstmembers
....
'DoCmd.Openform "change members", acPreview, , , acFormPropertySettings,
acWindowNormal

' DoCmd.Openform "change members"

' Forms![change members].Visible = False

Forms![change members]![MEM#] = ![MEM#]

DoCmd.Openform "Change members", , , windowmode:=acDialog ' wait for
the ok



.Edit

![MEM#] = Forms![change members]![MEM#] & ""

.Update

GoTo Agn


....
end with

If I execute as shown above the loading of the form 'change members' fails:
Forms![change members]![MEM#] = ![MEM#]

Because the form is not open.



Notice the 'goto agn' which starts the code again after some preliminaries
establishing the member.

Now that's the 2nd time thru. The form is open & the loading of the form
succeeds.



Notice the first 3 lines are commented out. I spent some time tiring
different methods of opening the form but no banana. HELP



You have me really confused here.

acDialog is NOT a command. It's an optional parameter specifying the
window mode in which the form will be opened.

And you don't "load a form with data" - a form is just a window ONTO
data. You can use the (again, optional) WhereCondition argument to
Openform (again, read the help file for details) to control which
record or records are visible in that window when the form opens.

I have NO trace of a notion what you mean by "2nd time around".

Could you a) post your code and b) describe what happens when the form
runs? maybe also what it's not doing that you'ld like it to do?
Remember, we can't see your screen!

John W. Vinson[MVP]


.

Loading