Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

This is the 'horse-before-the-cart' syndrome. Development before design. Happens much more often than thought.

Unfortunately, with the current process, to get this new customer into the list box and not lose the existing data would require a macro. You would enter the new customer and the macro would refresh just that control.

My choice would have a main form for the selected customer and a sub form for the sales (mentioned in comment of last question). Not only would it eliminate the need to choose a customer but it would automatically place this number in the appropriate field. So now before starting a sale first, you must choose or enter a customer. How this is all done would depend upon the method used.

Have attached a sample with your original form modified. Have added a button (macro attached to it - very small) which will refresh the lit in the list box. Also modified the list selection to present in alphabetical sequence by last name. Now you can add a new customer in the middle of entering an order then come back to the order, refresh the list & continue on.

Sample ------- RefreshListBox.odb

Note: You must enable macros for this to work.

Hello,

This is the 'horse-before-the-cart' syndrome. Development before design. Happens much more often than thought.

Unfortunately, with the current process, to get this new customer into the list box and not lose the existing data would require a macro. You would enter the new customer and the macro would refresh just that control.

My choice would have a main form for the selected customer and a sub form for the sales (mentioned in comment of last question). Not only would it eliminate the need to choose a customer but it would automatically place this number in the appropriate field. So now before starting a sale first, you must choose or enter a customer. How this is all done would depend upon the method used.

Have attached a sample with your original form modified. Have added a button (macro attached to it - very small) which will refresh the lit list in the list box. Also modified the list selection to present in alphabetical sequence by last name. Now you can add a new customer in the middle of entering an order then come back to the order, refresh the list & continue on.

Sample ------- RefreshListBox.odb

Note: You must enable macros for this to work.