A Small Form Question

  • Thread starter Thread starter Tom
  • Start date Start date
T

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.
 
Tom said:
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.
Click to expand...
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.
 
Back
Top