New Records from Form

[Jeremiah Gage]

I have a form to enter a School Name and a Date and when I click a
button on this form it opens another form with attendance data to be
edited. I have successfully been able to filter the second form with
the School Name and Date using a query, but what I need to do is if
there are no records that match that existing Date they need to be
created. What do I need to do to my query and/or form(s)?

 

[Ian Smith]

There is probably a better way, but what I've done in that
situation is to open up a recordset on the query the other
form is using, test for existance of the desired record,
and creating it with a recordset.addnew, if necessary,
before opening the other form.