Recent content by duck72

I'm using two side-by-side list boxes to select people from a list. (Once selected from the left-hand list, their names disappear from there and appear in the right-hand list.) This is like what the Form Wizard or Report WIzard does with fields. This is working fine, but it would be much...

Regarding the MsgBox problem, I THINK it was already addressed. For clarity, you want MyAnswer = MsgBox("Well?",vbYesNo) which means "set MyAnswer equal to the value of MsgBox," rather than the reverse, which asks Access to set the function value equal to the current...

How about the OldValue property? This is described as pertaining only to bound controls, but it definitely has a value once an unbound text box has been updated (by moving to a different control, for example). This makes me think it remains available during the BeforeUpdate procedure, while...

The subform is a form in its own right, but when it's on your main form it is the Form property of a subform control, and it doesn't process all the events that it would as a freestanding form. I suggest you try using the LostFocus event of the Subform control of the main form, e.g. Private...

Once you're sure the new entry has been saved in the table that provides the Row Source for the combo box control (which may require an explicit Save or Update command in your program), issuing MyCombo.Requery should make it show the new record in its properly sorted place.