var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ...Calling a procedure from a subform...Part 2
OK, this works fine...
Until I set the focus on x, x is a textbox on a subform.
Then I get Run-time error '424'
Public Function pft_asr_check_blanks()
x = Forms![frm_ent_pft_asr]![frm_ent_pft_asr_sub]![pft_asr_ee_revper]
If IsNull(x) = True Or x = "" Then
'Error Occurs Below
MsgBox "Please specifiy a review period."
I have an idea,
I'm not sure why you are using a Public Function, its not necessary. All you have to do is the following:
Lets name our Main form "Form1"
and our Sub Form "Form2"
and our Field on Form2 "Field1".
From the main form:
Private Sub Command_Click()
If IsNull(Forms!Form1!Form2!Field1) Then
MsgBox"Please enter data!"
Do Some Kind of Command
Just make sure you set the focus to the Sub Form before trying to set the focus to one of its fields..
Let me know if this helps