So I have run into a small problem with my forms. I have combo boxes for customer addresses and shipping company for their order. After I select a customer the shipping address combo box updates to show only address under the customerID, however when I select an address it doesn’t update the record in the table. Also whatever I select is the default address for the next customer even if it isn’t one of the customers address.
I have a similar problem with the shipping company I want the default to be blank until I select it however if I do select a shipping company it makes it the default for all the orders when I open the form, yet it doesn’t save except for the first entry. I think whatever fixes one problem should be able to work on the other, any ideas?
I have a similar problem with the shipping company I want the default to be blank until I select it however if I do select a shipping company it makes it the default for all the orders when I open the form, yet it doesn’t save except for the first entry. I think whatever fixes one problem should be able to work on the other, any ideas?
