Access Lock columns when the other is empty

[fcbuek]

Hi,
I have such a problem. In Access I have a form in which I have also inserted a subform in which there is only one column (NRB tables are linked one to many). I have a question whether it is possible to add a subform so that you can only enter some data in the NRB column as the TEST2 text field is filled in the main form.

I entered this code in the form

Private Sub Test2_Select() 
If (Test2.Value = "" Or IsNull(Test2.Value)) Then Test2.Select 
End Sub

But it doesn't work because I would like it to be impossible to enter data in the NRB column as the Test2 column is empty. I attach an example in the attachment.


Thank you in advance for your help.

[June7]

Instead of NRB_Click, use NRB_GotFocus for SelStart.

Clean up code. There is a sub for Check_GotFocus but I can't find a control named Check.

Code on main form to lock NRB textbox is incorrect syntax. Instead of locking NRB textbox, lock [NRB podformularz1] subform container control.

Private Sub Form_Current()
    Me.NRB_podformularz1.Locked = IsNull(Me.Test2)
End Sub

Private Sub TEST2_AfterUpdate()
    Me.NRB_podformularz1.Locked = IsNull(Me.Test2)
End Sub

Advise not to use spaces in naming convention.