B
Bender
What I am trying to accomplish:
When a user enters the DB and wants to update project data, I want to
use a simple search form that contains a combobox that is populated
with unique station names so that the user can make a selection and
then based on that selection opens another form with all the necessary
data and allows the user to update project data.
Current Functionality:
1. Created a form named "Project Name Lookup"
a. The form contains a a single Combobox that is populated by
querying a table with Unique Project Names with na "ok" and
"cancel" button
2. Created a macro named "Project Name Lookup"
a. Defined an OpenForm Action to open the Lookup form named Open
Dialog
b. Defined a Close Action to close the Lookup form named Close
Dialog
c. Defined a SetValue Action to set the value selected from the
combobox that is to be passed to a query in the "Project
Update" form when user clicks "ok" button.
3. Created a form named "Project Update"
a. The Form Record Src is set to a query "SELECT Projects.* FROM
Projects WHERE (((Projects.Station) = [Forms]![Project
Name Lookup]![StationName]"
b. The "On Open" parameter = Project Name Lookup.Open Dialog
c. The "On Close" parameter = Project Name Lookup.Close Dialog
My Issue:
I am trying to figure out why I get prompted with an "Enter Parameter
Value" popup when I open the "Project update" form. My understanding
is that the Search form should popup. At any rate, when I enter a
name the popup fades and then my search form (Project Name Lookup)
pops up and at this point I am able to make a selection which then
populates the "Project Update" form with the data I need. What I want
to happen is for the Project Name Lookup form to open when I open he
"Project Update" form without having to enter a "Parameter Value".
Does any one have any ideas on how to help.
My apologizes if my explanation is not clear enough.
Kindly,
Bender
When a user enters the DB and wants to update project data, I want to
use a simple search form that contains a combobox that is populated
with unique station names so that the user can make a selection and
then based on that selection opens another form with all the necessary
data and allows the user to update project data.
Current Functionality:
1. Created a form named "Project Name Lookup"
a. The form contains a a single Combobox that is populated by
querying a table with Unique Project Names with na "ok" and
"cancel" button
2. Created a macro named "Project Name Lookup"
a. Defined an OpenForm Action to open the Lookup form named Open
Dialog
b. Defined a Close Action to close the Lookup form named Close
Dialog
c. Defined a SetValue Action to set the value selected from the
combobox that is to be passed to a query in the "Project
Update" form when user clicks "ok" button.
3. Created a form named "Project Update"
a. The Form Record Src is set to a query "SELECT Projects.* FROM
Projects WHERE (((Projects.Station) = [Forms]![Project
Name Lookup]![StationName]"
b. The "On Open" parameter = Project Name Lookup.Open Dialog
c. The "On Close" parameter = Project Name Lookup.Close Dialog
My Issue:
I am trying to figure out why I get prompted with an "Enter Parameter
Value" popup when I open the "Project update" form. My understanding
is that the Search form should popup. At any rate, when I enter a
name the popup fades and then my search form (Project Name Lookup)
pops up and at this point I am able to make a selection which then
populates the "Project Update" form with the data I need. What I want
to happen is for the Project Name Lookup form to open when I open he
"Project Update" form without having to enter a "Parameter Value".
Does any one have any ideas on how to help.
My apologizes if my explanation is not clear enough.
Kindly,
Bender