Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cant get a combo box to update without closing form
Hello,
I have a quick question concerning combo boxes in forms and how to get them to update when changes are made to the underlying table. I have a main form that is pulling from a table. In the table there is a field called "supplier" that is a combo box that feeds off another table called "t supplier". On the main form i have the option to open up t supplier and add a name if the name isnt already in the t supplier table. The problem is when I add a supplier name, the recently added name does not appear in the combo box on the main form until i close the form completely. I have tried attaching a requery macro to upon click in the combo box, but for some reason that does not work. This seems like a pretty simple problem, but I cannot figure it out. If anyone can offer some guidance i would really appreciate it. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box input range automatic update | Excel Discussion (Misc queries) | |||
Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
Change the size of text used in a Form combo box | Excel Discussion (Misc queries) | |||
Closing a Form | Excel Discussion (Misc queries) | |||
Form Combo Box | Excel Discussion (Misc queries) |