Closing Pop Up Form

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have popup form that I use to create a customer on the fly from the order
creation form. Once I create the new customer, I requery the order creation
form from the popup so that it will dispaly the new customer. However after
the requery I am moved to the first record of the orders form.

How can I requery the orders form and keep the orders form on the same
record I was working with whenI called the popup form?
 
Mike,

Can you explain in a bit more specific detail what you are trying to do?
Requerying a continuous view form certainly relocates the focus to the
first record, and there are ways to deal with this. But I can't
understand why you are requerying the form. If you want to retain the
current record of the orders form, why don't you simply close the new
customer form, and you'll end up back where you were.
 
Thanks Steve

Here is an example. I am editing an order record (#10) on the main form. I
need to assign this order to a new customer that does not yet exist in the
database. I open the popup form and successfully create the new customer.
Now if I simply close the popup, the new customer will not appear on the
main form. Customers are assigned to orders from a combo box and unless I
requery the main form after creating the new customer, the combo box will
not refresh and the new customer will not be listed. So I requery the main
form and the new customer appears in the combo box but now the active record
has been moved to the first order record.(#1) and I must navigate back to my
original record (#10).

How do I preserve my position in the recordset after requerrying the form?
 
Mike,

Ok, that makes more sense now :-)

You don't need to requery the main form, I think you only need to
requery the customer combobox. Try that, and let us know.
 
Back
Top