Linked Sub-Form No Data

[RayMilhon]

I have a main form with a subform the main form consists of Patient Data and the subform consists of tests each patient has had. There are 6 possibilities. My problem is that if the patient hasn't had any of the tests yet the subform is completely blank so the user is unable to enter any new data. The main form and subform are linked by PatientID. How do I get the subform to display the fields so a new record can be added when none currently exist???

[Bob Fitz]

Check the "Allow Additions" property of the subform. This needs to be set to yes.

[RayMilhon]

It already is set to yes.

[Bob Fitz]

If the subform uses a query as its record source, are able to enter new records directly into the query.

[RayMilhon]

No, that was the issue. Modified the subform record source and it now works the way I want it to. Instead of using the query I used the table with the filter and filteron properties to limit the data the way the query did. Works like a charm. Wish I'd thought of that earlier would've saved me a couple of hours banging my head against a wall.

[Bob Fitz]

No, that was the issue. Modified the subform record source and it now works the way I want it to. Instead of using the query I used the table with the filter and filteron properties to limit the data the way the query did. Works like a charm. Wish I'd thought of that earlier would've saved me a couple of hours banging my head against a wall.

Ray, just enjoy the lack of head banging now.