ReQuery Help

[Guest]

Hi
I built a form based on a query to create an invoice. I have a field in the
invoice called suppliers and when you double click the field it automatically
opens up a form called supplier in the add mode so you can add new suppliers
to the invoice on the fly. The trouble is that when I added a new supplier it
didn't show up immediately inside the form and so i opened the form in design
view and right clicked the supplier field and went to the event tab and
created an afterupdate event that says Me.Supplier.Requery.

That works great as long as I only add one supplier at a time. If I add a
second supplier the second supplier is no longer there. Is there something
else I can try? Any suggestions would be appreciated

Thanks

 

[Brian Bastl]

what is the code for opening your Supplier form?

I'd think that the following should work:

DoCmd.OpenForm "Supplier", , , , acFormAdd, acDialog
Me.[SupplierCombo].Requery 'combobox on Invoice form

Is this what you're doing?

Brian