Thank you John, that allowed the second form to come up
without the small parameter window, but now the value
that is in Application Name, isn't the value pulled into
the second form. It actually lists the first value in
the table for the Application Name. In the first form,
Application Name is a drop down list, could this be why
the value is not being transferred? If so, is there a
way to set it so that the value that is picked from the
drop down list is what is transferred?
Thanks agagin for your help!
>-----Original Message-----
>
[quoted text clipped - 33 lines]
> John W. Vinson[MVP]
>.
John Vinson - 15 Apr 2005 18:14 GMT
>Thank you John, that allowed the second form to come up
>without the small parameter window, but now the value
[quoted text clipped - 5 lines]
>way to set it so that the value that is picked from the
>drop down list is what is transferred?
I have no idea how your tables are structured, so I'm not at all sure
what field should be passed. Remember: a combo box ("dropdown") is NOT
data; it's a display tool. The value stored in the table is NOT
necexsarily the same as the value that you see; in fact it usually
isn't!
If you pass the value of the combo box in your code, what will be
passed is the bound column - which may well be an invisible numeric
ID. On the second form, you should also have an invisible numeric ID
and it's that field which should be set.
John W. Vinson[MVP]