Subform Help!!

[kufre]

I'm using Access 97, I have a problem with my form. I have a subform
inside my form. I would like to diable the subform if submission
number is 1 and enable it if it is greater than 1. I will only use the
subform if submission number is greater than 1. or make it a subform a
require field if submission number is greater than one. I've try
several code but none of them seem to be working.
Private Sub Submission_Number_AfterUpdate()
If Me!Submission_Number = 1 Then
Me.tblFiling_subform.Visible = False
Else
Me.tblFiling_subform.Visible = True
Please help, any suggestion would be greatly appreciate.

[PC Datasheet]

Also put your code in the main firm's Current event.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"kufre" <ku********@yahoo.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...

I'm using Access 97, I have a problem with my form. I have a subform
inside my form. I would like to diable the subform if submission
number is 1 and enable it if it is greater than 1. I will only use the
subform if submission number is greater than 1. or make it a subform a
require field if submission number is greater than one. I've try
several code but none of them seem to be working.
Private Sub Submission_Number_AfterUpdate()
If Me!Submission_Number = 1 Then
Me.tblFiling_subform.Visible = False
Else
Me.tblFiling_subform.Visible = True
Please help, any suggestion would be greatly appreciate.

[kufre]

I try putting this code into the form's current event but I keep
getting a error message "Microsoft Access Can't find the field
'Submission_Number referred to in your expression". I'm not sure what
that mean. I'm also not sure why I should put the code in the main
form's current event. Please explain.

Thank you in advance.