K
krempin
I have a subform with fields that are populated with the results of a query
based on a variable supplied by the parent form - in this case the variable
is a "part number".
The query I am using is "SELECT [Query].Var1, [Query].Var2, ..., FROM
[Query];"
How do I get the fields in the subform to default to a NULL or something
when it the form is initially launched and then also if the query on the
"part number" supplied by the parent form does not return a valid record?
Currently, the fields in the subform are populated with the data from the
1st record in the database both when it is initially launche and also if the
"part number" is not found by the query. ~thanks!
based on a variable supplied by the parent form - in this case the variable
is a "part number".
The query I am using is "SELECT [Query].Var1, [Query].Var2, ..., FROM
[Query];"
How do I get the fields in the subform to default to a NULL or something
when it the form is initially launched and then also if the query on the
"part number" supplied by the parent form does not return a valid record?
Currently, the fields in the subform are populated with the data from the
1st record in the database both when it is initially launche and also if the
"part number" is not found by the query. ~thanks!