Data_Entry in property sheet changes to NO when form opens

[neelsfer]

When i open a form from another form using a specific record, my data entry property in a subform is "automatically" set to false (no) it seems.

The 2nd form opens 100% on the correct record, but the data entry allows all previous records to be displayed. I need no records to be displayed in the subform.
I have tried this without success

DoCmd.OpenForm "CyclistF", , , "[cyclistid]=" & Me![cyclistId2]
[Forms]![cyclistf]![RaceEntriesSF].DataEntry = True

Any suggestions

[Seth Schrock]

Try this:

DoCmd.OpenForm FormName:="CyclistF", DataMode:=acFormAdd, WhereCondition:="[cyclistid]=" & Me![cyclistId2]

I haven't tried it personally, but from the MSDN website, I believe that this has a chance of working ;)

[neelsfer]

thx Seth for the lightning fast response
It works but clears everything when it opens - the main form as well as the subform. How can i zoom in on subform only, but continue to show the parent form record? any suggestions?

[Seth Schrock]

I missed the subform detail. It turns out that your guess was closer than mine :) Change your reference to the subform to

[Forms]![cyclistf]![RaceEntriesSF].Form.DataEntry = True

The way that subforms work is that a form resides inside a subform control. Your code referenced just the control. By adding the .Form after the form name, it references the form inside the subform control. Then you have access to all the form properties as well as the controls on the subform.

[NeoPa]

[Forms]![cyclistf]![RaceEntriesSF].Form.DataEntry = True

or

[Forms]![cyclistf]![RaceEntriesSF]!DataEntry = True

will both work (See Referring to Items on a Sub-Form).

Other questions, related or not, need to be asked in separate threads Neels.

[neelsfer]

thx Neopa - i meant to ask a related question. Seth's solution above cleared the subform as well as the parent form records, and i wanted to focus on the subform data entry property actially.
I have tried the above solutions but it still seem to do the same thing. Something else on my parent or subform must be affecting it somehow. i will probably have time tomorrow to try more options.

[NeoPa]

If it's further on the same problem - generally because the answers already there don't quite solve it - then that can come in the same thread. Otherwise, it really needs to be asked separately, even if you want to post a link to the original in your new thread, which is perfectly acceptable.

As for the current situation - Are you saying that the subform and the main form always seem to keep in step? IE. Whichever way one is set then the other necessarily follows.

If so, then this may be a fundamental design constraint within Access itself. It may be that it is considered not to make sense that they can be different. Frankly, I've never given the idea much thought.

Am I right in thinking you want the main form to show various records to choose from, but the subform to provide a means to enter only new data related to the selected record of the main form only?