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]