D
deegs4
I am trying to use a value (two values, actually) from a given record on a
form (form1) to display another form (form2), in datasheet view, that
displays only the records that match the two values from the record I was
viewing in form1.
I have tried using a macro that opens form2 and uses a where condition in
the arguments. This MIGHT work but it is running far two slowly. The query
data behind form2 is being accessed through ODBC and is a very large (thus
pokey) dataset.
If I enter the query and manually enter the two values in the query, opening
form2 only takes a few moments. What is guess happens with the openform
macro is that the query is run without any parameters (this would take a very
long time) then the resultant dataset is filtered based on the values I
passed.
Any ideas?
form (form1) to display another form (form2), in datasheet view, that
displays only the records that match the two values from the record I was
viewing in form1.
I have tried using a macro that opens form2 and uses a where condition in
the arguments. This MIGHT work but it is running far two slowly. The query
data behind form2 is being accessed through ODBC and is a very large (thus
pokey) dataset.
If I enter the query and manually enter the two values in the query, opening
form2 only takes a few moments. What is guess happens with the openform
macro is that the query is run without any parameters (this would take a very
long time) then the resultant dataset is filtered based on the values I
passed.
Any ideas?