Prev: 1 combo box populating more than one field and retaining info to t
Next: Hide one page within a form with several pages
From: DJS on 12 Jan 2010 20:45 Hi I have a similar "problem" - I think this type of scenario is common. I have my comboxs synchronising ok but I do not want to stre redundent data. I only want to update a field bound to lat combo e.g store the product but I don't need to store the category as I can find it by lookup or joining tables later. So I have made the first combo unbound it narrows the second combo and its value is stored. This means I need code in the form current event to ensure the first (unbound combo) has its value selected based on data in the second. This all works fine - the only problem is during data entry if the user does an "undo" the comboboxes are not always reset to their original values. Any suggestions. I think if I store redundant data ie make all comboboxes bound this is not a problem. "Info" wrote: > Is possible to synchronize three or more combo box at once? If do, can show > me the way or the code please, thanks for the support. |