Refresh subform after lookup

[vnbuser]

First off: I love nuBuilder. I use it to bring an Access-based non-profit to the current millenium.

I have everything, more or less, running and I am trying to improve usability. As internet is not very responsive at the location I am trying to minimize reloads and switching of screens.

This is my current challenge:
Think of an invoice/order situation. What is currently working is: Picking a member from the members table have her details in a form and orders (from an order table) in a sub form. I need to and can add multiple orders and save everything. Unfortunately saving and picking the next member takes some time.

What I think would be faster is a form with a lookup of the member, a subform of her orders and a save button. Unfortunately I am unable to update the subform after having performed the lookup. When pushing the save button only the subform is saved.

If it is possible, can someone please point me to a solution/tutorial? I did not find an answer in the forum nor on the web.

Kind regards,

Joe

[admin]

Joe,

I would make the main Form linked to customer and use the Close button instead of the Save button.
That way, after saving you would be taken back to a Browse Form of customers where you can easily chose the next customer.

Steven

[vnbuser]

Steven,

Thanks for your reply. This is exactly how I ended up doing it while waiting for an answer. It turns out that it works fine. Limiting the the number of displayed fields and rows to the bare minimum decreases load and save time a lot.

Regards,

Joe

[admin]

.