Open Form with Where - then Combobox

[Guest]

Am using a macro does a series of queries, which in the end opens a Form
using the macro's OpenForm Where condition so the form opens to a specific
record i.e. ID=[value of Id that is found elsewhere]

and it works great.

but after the user sees this data they will want to continue with this form
to see another record and the combobox on this form that would be used to
find another record is in active because this form is now filtered to just
this one record...

so although using the Where parameter in the Macro works; it prevents the
form from accessing all the other records....

I guess I could recreate the Macro with VB which maybe is the only solution
but thought I would first ask around whether there is different method in the
Macro to both open to a specific record and also allow the form to have all
records available to it.....

t.i.a.

 

[Guest]

Have you tried using macro step FindRecord instead of Where condition?

 

[Guest]

glad I asked - thanks - never had used that feature before and didn't realize
it was there....works great, thanks again.
--
NTC

Have you tried using macro step FindRecord instead of Where condition?
--
KARL DEWEY
Build a little - Test a little

Am using a macro does a series of queries, which in the end opens a Form
using the macro's OpenForm Where condition so the form opens to a specific
record i.e. ID=[value of Id that is found elsewhere]

and it works great.

but after the user sees this data they will want to continue with this form
to see another record and the combobox on this form that would be used to
find another record is in active because this form is now filtered to just
this one record...

so although using the Where parameter in the Macro works; it prevents the
form from accessing all the other records....

I guess I could recreate the Macro with VB which maybe is the only solution
but thought I would first ask around whether there is different method in the
Macro to both open to a specific record and also allow the form to have all
records available to it.....

t.i.a.