I have a quotation form where the user select a customer from a dropdown combo box. Next to that cbo box is 2 buttons: a lookup button to open the customer form to the selected customer data
and a "new" button that opens the customer form to a new record to add a new customer.
Here is my problem: when i was running the database locally (not on the server) i could click on the "new" button, open the customer form, add a new customer, close the customer form, then on my quotation form i could click on the cbo box and see the new entry.
Since I moved the database on the server i can't do this anymore. I can add the new customer but when i click on the cbo box the new entry isn't there. I need to close my quotation form and reopen it to then see it on the drop down combo box list.
Why is it doing this?
and how do I solve this?
cbobox name: cmbCust ; control source: RefCustomer on tblquotations
and a "new" button that opens the customer form to a new record to add a new customer.
Here is my problem: when i was running the database locally (not on the server) i could click on the "new" button, open the customer form, add a new customer, close the customer form, then on my quotation form i could click on the cbo box and see the new entry.
Since I moved the database on the server i can't do this anymore. I can add the new customer but when i click on the cbo box the new entry isn't there. I need to close my quotation form and reopen it to then see it on the drop down combo box list.
Why is it doing this?
and how do I solve this?
cbobox name: cmbCust ; control source: RefCustomer on tblquotations
