Hide Empty (New) record in continuouse form

R

RoadKyng

Greetings.
I have a main form with a subform that may have a maximum of 3 records
(extension events). I have the subform set to a continuous form so all events
will show for each main record. When entering the first subform record Access
automatically opens a new empty record. Is there a way to hide this
non-existant record? My problem is all main records display at least 2 sub
events (one is empty). I want to only display what is there.

thanks
 
S

Sandra Daigle

Just set the AllowAdditions property of the form to false. You will then
need to provide a method for adding a record - a command button which resets
the property to True is usually sufficient. Then use the AfterUpdate event
to set it back to false.
 
D

Damon Heron

You can put a routine in the current event (of the main form) to test for
empty record, and make the subform invisible or some of the controls in the
subform invisible when desired.
What value links the mainform with the subform? Start there.
 
Top