Modal = Yes Locks the Record

[rm]

From form A I have the following code

DoCmd.OpenForm "B", acNormal, , , , , "rbshortname|" & Me.rbshortname

In form B the following

Me.Caption = Me.Caption & Space(1) & "-" & Space(1) & strRBSName &
Space(1) & Format(Now(), "mm/dd/yy HHMM")

Form B contains a combo box

If form b is set to Modal = yes then the user cannot change the value
in the combobox

If form b is set to Modal = no then the user can change the value

What am I missing?

 

[Jeanette Cunningham]

Using A2007, I created a new form based on a table.
I added a combo box with a row source and I was able to change the value in
the combo every time.
Whether the form had modal set to yes or modal set to no, made no
difference.
This is what I expected to find.

There could be something else on your form that is causing the combo to
lock.

Comment out all the code on the form and see if you can use the combo when
the form is modal.
If yes, then uncomment the code routines one by one to see which one is the
culprit.

If that doesn't help, build a new form from scratch.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia