Re: GUI for access 2002

Ok got it mostly working :-(.

1.I execute a command button that loads the form with data from a members
data.
2.Then cmd.openform formname,windowmode:=acdialog
3.Operator would make any changes to the data needed.
4.Execute a command button that ....visible=false
5.That turns the code loose to change any data in the members data as you
said

However that only works the 2nd time around :-(

So I tried cmd.openform formname ...
before loading the form with members data 1. above with a bunch of options
but no banana
With this then 2. above doesn't stop anymore

So what can I do to load the form with data before the acdialog command? TIA

"John Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:k5ofk2ho37vc09mg8cdk1aiqboa9jr8dql@xxxxxxxxxx
On Tue, 31 Oct 2006 23:39:10 GMT, "TED MEDIN" <mmaphq@xxxxxxxxxxx>
wrote:

Dialog form would fit what we are currently doing. However, I have no idea
how to open a dialog form.

This is what the vba code looks like:

docmd.openform formname,,,stlinkcritera ' have no idea what
stlinkcritera does
while isformopen(formname) then
strtmp=[form]![formname]![text0] & ""
...
doevents
wend

stLinkCriteria is an optional argument which specifies which records
are displayed on the Form. If it's blank you'll see the entire
Recordsource of the form; if it's a valid SQL WHERE clause (without
the word WHERE) you'll see just the records which match that
criterion.

If you use

DoCmd.OpenForm formname, WindowMode:=acDialog

it will open the form in dialog view. The execution of your code will
STOP - no additional lines will be executed until either the form is
closed or is made invisible. There's no need for the While...Wend
loop.

You might want to look at the VBA Help file for the OpenForm method;
there are a number of optional arguments which you may find useful.

John W. Vinson[MVP]


.