Remove Link to Related Records in Form

[RJP]

I have a Datasheet view of a form and it displays a "+" symbol. When expanded it returns a list of related records. How do I get rid of the "+" in my form?

 

[BarryMK]

I have a Datasheet view of a form and it displays a "+" symbol. When expanded it returns a list of related records. How do I get rid of the "+" in my form?

Are you sure this is a datasheet view of a form? It looks like a table to me, but I could be wrong.

 

[RJP]

It is definetly a datasheet view of a form.

 

[MartijnR]

Make the datasheet a continous form

Sounds like you have related records and unless you want to break the relation, they will show.

But if someone knows how to not show them, plz inform us

 

[RuralGuy]

PMFJI,
I just did a test in ac2K2 and a form in DataSheet view with related table 1:M does *not* show the "+" sign. Only opening the table directly shows that. What version of Access and OS do you use?

 

[MartijnR]

I just tested in 2003 and i do see '+' in a datasheetview of a form, tested again with another table and didn't see the '+'

I guess you have at least 1 subform on the form you view as datasheet

 

[RJP]

Thanks for helping target the why.

Recap: I have a master form and there is a subform within it. When I change the master form to datasheet view the "+" is displayed. This opens the subform.

The problem is I am maintaining someone else's application and it is probably the worse code I have ever seen. The application is like a big Jenga game. You move one block and the whole thing wants to collapse. That being said if possible I need a fairly simple solution that won't necessitate me reworking the entire application as this problem occurs in many places.

For some strange reason the developer decided to switch between Form & Datasheet view instead of coding a new datasheet view form.

I have prepped a simple example with 2 forms to illustrate the problem. If you have any recommendations please let me know.

 

[MartijnR]

I've looked at the sample and I think it's not that difficult to help you out here

I changed the master form to single form in it's properties and I changed the child form to continous form (and moved the fields a bit, the labels in form header). Looked like it should? Ok, you can do more on the visual part like setting no to dividing lines, records navigator, etc

 

[RJP]

The problem is that in the code this guy wrote he uses the Master form as a full data entry application with multiple tabs and tons of validation. He then changes the view of the Master Form to datasheet to perform some selection mechanisms. The user then selects a record and it switches the Master form back to the main single form view. The problem is that I hoped there was a simple way to keep hide the "+" sign when the Master form is in datasheet view.