A Small Form Question

[Tom]

I know this is simple, but I just can't seem to make it
work.

I have two forms. On the first form there is a combo box
with a list of names. Once a name is chosen there is a
button to press which opens form 2. What I need is a
different combo box on the second from, that reads from
the same table of names, to default to the name selected
on the first form. I've tried using the standard [forms]!
[form1]![combo1] in the default value option of the second
combo box but it just comes up with no default value on
the second form.

Any suggestions would be greatly appreciated.

 

[Mike Painter]

I know this is simple, but I just can't seem to make it
work.

I have two forms. On the first form there is a combo box
with a list of names. Once a name is chosen there is a
button to press which opens form 2. What I need is a
different combo box on the second from, that reads from
the same table of names, to default to the name selected
on the first form. I've tried using the standard [forms]!
[form1]![combo1] in the default value option of the second
combo box but it just comes up with no default value on
the second form.

Any suggestions would be greatly appreciated.

Making form 2 a subform would be the easiest way and there would be no
button needed.
Using the openargs part of docmd.openform would be another way.
Opening the form based on a query with forms!form1!combobox would be another
way.