Recent content by Sabilah

for more clear, I want to do a looping like sample attached. case 1 is ok case 2 is NG because Cid < MCav, user cannot update the Mid.

I'm also write this code. It's work for more than MCav. What I want if Cid is less than MCav, User not allow to update for new Mid. Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.CMID > Forms![Navigation form]![NavigationSubform].[Form]![MCAV] - 1 Then MsgBox "MORE THAN MId...

Sorry ..I'm stuck in Recordsetclone.:mad: Need a help and attached the accdb.

Yap...is correct. Thank I will check with Mr google.:)

Noted and Thanks. But the looping still ng

Hi..I need a help on my looping: In the main form, I have textbox MID=M123456 and CAV=4 In sub form, a. I have CID and DateTime. b. I add MCID =Count(MID) I want to do a looping for CID <= CAV if >4,msgbox "More than CAV" then undo if <>4,msgbox "Less than CAV" then MID will lock...