If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Update table when entry is saved
"John W. Vinson" wrote in message ... On Tue, 2 Feb 2010 11:06:32 -0800, "Jan :\)" wrote: "John W. Vinson" wrote in message ... On Tue, 2 Feb 2010 07:07:57 -0800, "Jan :\)" wrote: You have not said what you're using as the RowSources of these combo boxes. Are they value lists? lookup tables? Select Distinct from your main table? or what? RowSource is Select Distinct, such as: SELECT DISTINCT tblMeds.Provider FROM tblMeds; In that case just requery each Combo Box individually in the Form's AfterUpdate or Current event. Overkill and will usually waste time but it'll work. Thanks, John. I appreciate your time and help. Jan You're welcome. It's great to see your smiling face! Wasn't sure you'd remember me. I sure do miss you all! :-) Jan -- John W. Vinson [MVP] |
|
Thread Tools | |
Display Modes | |
|
|