T
Tazzy via AccessMonster.com
Hi All,
Wonder if someone can help me with this one please. I have a database
containing records of a number of students on day release activities that
also includes the school they attend. On the form that contains their data I
have a tabbed subform for search/filter options. I have set up queries for
finding schools or students by surname and entered their details in the
criteria as '* & [Enter Surname]', obviously changing it to [Enter School]
for the other one. I have tested the queries and they work perfectly. I have
assigned a command button to run these queries via a simple macro (still
finding codes a difficult task) and they work fine giving me the prompt
[Enter Surname]. I also have another command button to reset all records,
this also appears to work fine. The problem I have is that if I then want to
do another filter and click the command button, I no longer get the prompt
for [Enter Surname] etc, it just runs the query with the same data again,
even after I have exited the database and started it up again. Running the
queries separately again shows them working without any problem. I'm running
Access 2000 by the way.
Would appreciate any help (step by step if really complex) that anyone could
give.
Thanks in advance
Tazzy
Wonder if someone can help me with this one please. I have a database
containing records of a number of students on day release activities that
also includes the school they attend. On the form that contains their data I
have a tabbed subform for search/filter options. I have set up queries for
finding schools or students by surname and entered their details in the
criteria as '* & [Enter Surname]', obviously changing it to [Enter School]
for the other one. I have tested the queries and they work perfectly. I have
assigned a command button to run these queries via a simple macro (still
finding codes a difficult task) and they work fine giving me the prompt
[Enter Surname]. I also have another command button to reset all records,
this also appears to work fine. The problem I have is that if I then want to
do another filter and click the command button, I no longer get the prompt
for [Enter Surname] etc, it just runs the query with the same data again,
even after I have exited the database and started it up again. Running the
queries separately again shows them working without any problem. I'm running
Access 2000 by the way.
Would appreciate any help (step by step if really complex) that anyone could
give.
Thanks in advance
Tazzy