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.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1