J
Jenni
Hi.
I am writing a Interactive Quiz database. I need to know how to requery a
form after I add a new "blank" quiz question. This is the scenario.
I have a list box which selects all the quiz names. The user would then
double-click the list box on the desired quiz and the OnDoubleClick event
then opens the edit questions form which goes to the first record of the
selected quiz (this form has a query as its record source) To add a new
record I have an append query that takes the quizno and name and appends it
to the source table that the record source query reads from.
I know I need to requery the form to get the record to show up in the form
but how can I get it to jump to the added record?
The other problem I have is that the results from the OnDoubleClick jumps to
the first record of the query I want the user to be able to edit ok, but if
they keep clicking the next record command button it goes through all the
records and then goes on to the first question of the next quiz. if I try to
restrict the crieria in the record source WHERE statement with the quiz
number from the form the control boxes disappear. However, if I dont then
the user can, if they are not vigilant edit questions that they should not be
able to view.
I am new to VBA coding within Access so please, if you can help me be
prepared to break it down into simple terms if necessary, thanks
I am writing a Interactive Quiz database. I need to know how to requery a
form after I add a new "blank" quiz question. This is the scenario.
I have a list box which selects all the quiz names. The user would then
double-click the list box on the desired quiz and the OnDoubleClick event
then opens the edit questions form which goes to the first record of the
selected quiz (this form has a query as its record source) To add a new
record I have an append query that takes the quizno and name and appends it
to the source table that the record source query reads from.
I know I need to requery the form to get the record to show up in the form
but how can I get it to jump to the added record?
The other problem I have is that the results from the OnDoubleClick jumps to
the first record of the query I want the user to be able to edit ok, but if
they keep clicking the next record command button it goes through all the
records and then goes on to the first question of the next quiz. if I try to
restrict the crieria in the record source WHERE statement with the quiz
number from the form the control boxes disappear. However, if I dont then
the user can, if they are not vigilant edit questions that they should not be
able to view.
I am new to VBA coding within Access so please, if you can help me be
prepared to break it down into simple terms if necessary, thanks