Hide Empty (New) record in continuouse form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
Back
Top