Subform Open to Add New Record

[Hey Lucy]

I have a subform for notes on another form. Is there any way for the subform to display with a new blank field at the top for adding a new record? Currently, the user has to enter the date of the note and the note itself. I have them arranged in descending order so the most current note shows first. I just wondered if there was a way to have the first row be an "add new record" row.

Thanks!

 

[boblarson]

There is no way to do it directly. But you can do it in a different way. Have a set of text boxes to sit above the subform (if using datasheet view for the subform) or on the subform header (if using continuous form format) and have the entry go into those. Then use an append query to append the values using a button and then requery the subform.

 

[John Big Booty]

I don't believe there is any way of directly achieving what you are after. One way you could achieve this would be to disallow data entry on the subform, and instead use a pop up form to enter new records

 

[Hey Lucy]

Thanks for the suggestion, John. I couldn't find any way to have it open to an add new record mode.

 

[John Big Booty]

The sample here demonstrates the method, I described, and could be quiet easily adapted to work as Bob has suggested.