On Wed, 13 Dec 2006 04:49:16 GMT, mdavis via AccessMonster.com wrote:

This works great.
But now if I delete the record that is in COMBO B how do I make the COMMAND
BUTTON enabled so that I can enter another record?

fredg wrote:
One more thing. When I close Form B and reopen it the command button is
enabled.
[quoted text clipped - 16 lines]
Forms!FormB!AnyOtherControl.SetFocus
Forms!FormB!CommandButton.Enabled = False

Code the Form's Current event:
Me!CommandButtonName.Enabled = Not IsNull(ComboB)

in which case there will most likely be no need to set it from FormA.


Place the same code in the ComboB AfterUpdate event.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail