G
Guest
I have a form with a combo box which users use to select records and display
the information on the form. No prob here
Also displayed is a subform which also displays certain fields from other
records that are related to the record displayed on the main form. No probs
here.
I also have a command button displayed next to each record on the subform,
this button when clicked places the record in view on the main form.
My problem is that when this happens the form will only display the record
selected by the command button and to view any other records through the main
form I have to close it and re-open it, at which point everything works fine
again.
I have tried various versions of the Requery command. I have initially
inserted a command button on the main form to do the requery, until I get the
code right, at which point I will move the code to the appropriate event to
automate the process.
I have tried
Version 1
Me.Requery
Version 2
Combo22.Requery (Combo22 is the name of the Combo on the main form)
Version 3
forms![Sample Results].Requery ([Sample Results] is the name of the
main form
Can anyone help with my problem.
Many thanks
Richard
the information on the form. No prob here
Also displayed is a subform which also displays certain fields from other
records that are related to the record displayed on the main form. No probs
here.
I also have a command button displayed next to each record on the subform,
this button when clicked places the record in view on the main form.
My problem is that when this happens the form will only display the record
selected by the command button and to view any other records through the main
form I have to close it and re-open it, at which point everything works fine
again.
I have tried various versions of the Requery command. I have initially
inserted a command button on the main form to do the requery, until I get the
code right, at which point I will move the code to the appropriate event to
automate the process.
I have tried
Version 1
Me.Requery
Version 2
Combo22.Requery (Combo22 is the name of the Combo on the main form)
Version 3
forms![Sample Results].Requery ([Sample Results] is the name of the
main form
Can anyone help with my problem.
Many thanks
Richard