Can I hide/remove the field that joins subform to main form?

[Rachel Garrett]

Greetings,

I have a subform that is joined to the main form on an ID field. The
users don't care about the ID number, so I'd like to hide it.

What is the proper way to do this? Should I just set that field and
its label to visible=false, or is there a better method?

Thanks,
Rachel

 

[John W. Vinson]

Greetings,

I have a subform that is joined to the main form on an ID field. The
users don't care about the ID number, so I'd like to hide it.

What is the proper way to do this? Should I just set that field and
its label to visible=false, or is there a better method?

Thanks,
Rachel

If the Master Link Field is the name of a field in the form's recordsource,
then there's no need to have a textbox or other control on the form at all. If
you for some reason want a control on the form as the Master Link Field (for
instance it's a "relay" textbox to correlate two subforms) you can set its
Visible property to No.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com