J
JK
Another one I cannot figure out
When I add a record that affect the list in a combo box, understandably that
the combo box is not updated until I manually refresh it in some way,
usually by sending the F9 key. Is there a way to automate it?
Example:
Form Invoice (invoice header - name, address, date etc)
Subform Invoice Details
Product_ID (Combo), Quantity, Price, Line Total (calculated) etc.
On occasions a product has to be created during invoicing. a Double click on
the combo box (or by other means) will open the Product Setup Form and a new
product is added. when the Product form is closed the new product does not
appear in the Product_ID list (in the Invoice Details) unless the F9 key is
press.
I tried OnGotFocus event (Requery) but that would only work if I get out of
the combo box and come back into it. I suspect that I'm using the wrong
event /Action but can't figure out the right way
Any Idea?
Regards/JK
When I add a record that affect the list in a combo box, understandably that
the combo box is not updated until I manually refresh it in some way,
usually by sending the F9 key. Is there a way to automate it?
Example:
Form Invoice (invoice header - name, address, date etc)
Subform Invoice Details
Product_ID (Combo), Quantity, Price, Line Total (calculated) etc.
On occasions a product has to be created during invoicing. a Double click on
the combo box (or by other means) will open the Product Setup Form and a new
product is added. when the Product form is closed the new product does not
appear in the Product_ID list (in the Invoice Details) unless the F9 key is
press.
I tried OnGotFocus event (Requery) but that would only work if I get out of
the combo box and come back into it. I suspect that I'm using the wrong
event /Action but can't figure out the right way
Any Idea?
Regards/JK