M
Macsmasher
Running Access 07.
I have Form1, from which I launch Form2 with the same data and always goes
to the same record as Form1. I make changes to that data on Form2. When I
close it, I want to requery Form1 (refresh doesn't do it). But the problem
with Requery is that you are then at the beginning of the recordset rather
than the current record on which you're working.
I want to Requery Form1 when closing Form2, and remain at that current
record rather than the beginning of the records. I'm sure it's easy, but I
can't seem to do it.
Thanks in advance,
Larry
I have Form1, from which I launch Form2 with the same data and always goes
to the same record as Form1. I make changes to that data on Form2. When I
close it, I want to requery Form1 (refresh doesn't do it). But the problem
with Requery is that you are then at the beginning of the recordset rather
than the current record on which you're working.
I want to Requery Form1 when closing Form2, and remain at that current
record rather than the beginning of the records. I'm sure it's easy, but I
can't seem to do it.
Thanks in advance,
Larry