macro/subform event

G

Guest

I want my macro to evaluate if a field in a SUBFORM is null, and if not,
allow the user to click an option radio button. If the field IS null, then
the user shouldn't be allowed to click. Sounds easy enough, right?

I have this as a condition in my macro:
[Forms]![frmupdatecaseentry]![SelectedStatusNumber]=6 And
[Forms]![fromCaseFeatureSubform]![FeatureDateClosed] Is Null

The problem is that I get an error message to the effect of "Can't find the
subform 'fromCaseFeatureSubform'" - as though it doesn't recognize that the
subform is open (the subform IS in fact open inside the frmupdatecaseentry
main form).

I've tried using the .form suffix after my subfrom name, but that doesn't
seem to work. Any other ideas?
 
A

Allen Browne

Subforms are not open in its own right, i.e. they are not part of the forms
collection.

Try referring to the text box like this:
[Forms]![frmupdatecaseentry]![fromCaseFeatureSubform].Form![FeatureDateClosed]

For an explanation, see:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DCount with a subform 3
verify a date in a subform 1
Parameter Value error in a Subform 0
Macro referencing a subform, in a tab, in a parent form 3
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Generate Autonumber on subform 7
COMPARING VALUES IN FORM/SUBFORM 3
Open form for record selected in subform 2

Top