Hide a button in the main form when a field in a sub from is empty

[terjeo]

I have a main form called "Main", and a sub form called "Edit". In the form "Edit" there is a field called "Other_info".

When the field "Other_info" is blank, I want to hide the button "Other Info" in the main form.

I try to use the IsNull function, but I need help for the whole string.

I hope this is understandable.



Thank you for all help.

[Micron]

What view is the subform in the main form? If it's a continuous or datasheet view it will depend on which record is the active/selected record and what the value in that field is on that record. Thus the button might be seen if on one record but not if on another. If the subform is only showing one record, then it will depend only on that record. I'd say it's a bit unusual to show only one record in a subform but thought it best to ask.

You could try this on the subform in the Current event:

If Len(Me.Parent.Other_info) & vbNullString = "" Then Me.Parent.myCommandButton.Visible = False
Could also use Nz function: If Nz(Me.Parent.Other_info,"") = "" Then...

I might have the Parent reference incorrect - I rarely use it.

EDIT - corrected reference to button. It was pointing to the subform, not the main form.

[Welshgasman]

I would assume that the subform is tied to the mainform in some way?
So on the subform current event

me.parent.cmdOther_Info.visible = len(me.other_info & "") > 0

[terjeo]

The main form is read only, and the sub form is where I edit the data. Both forms show only one record at the time. The database is a member register.
I will try what you suggest.

Thanks