I have a split form, how can I add a subform without there also being a subdatasheet?

wmphoto

Registered User.
Local time
Today, 17:44
Joined
May 25, 2011
Messages
77
I have a split form, I have included a screencap below:

As you can possibly see, this is showing data on commissions (I'm a professional photographer) and this is a record created to test the database. Commissions is one table and most of the data visible in the screencap is from that table. There is a another table called Appointments, and the Commissions-Appointments relationship is one-many. Towards the bottom of the form you can see a subform listing the appointments which are associated with that commission.

To the left of the form you can see the datasheet for this form as it is a split form. I have hidden most of the rows as I simple want the datasheet there to help me navigate through commissions.

My problem though is that because I have the appointments subform, there is also an appointments sub-datasheet (you can see the little +'s next to the records in the datasheet). I don't want this, also because there are 3 appointments for the 'TEST' commission, it appears 3 times in the datasheet. I have no idea about this either.
 

Attachments

  • subform.jpg
    subform.jpg
    100.9 KB · Views: 310
Sorry, I figured out why 'TEST' appeared three times. While trying to find a way of combining a list of appointments and detailed expenses for the selected appointment on one form I added some fields from appointments to the form and ended up with a form based on a query based on appointments instead of a form based on commissions.

I would still appreciate help on getting shot of the sub-datasheets though.
 

Users who are viewing this thread

Back
Top Bottom