Changes to Subforms - Microsoft Access Expert 10


	Back to Access Expert 10 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Changes to Subforms

Shallena Ayers

11 months ago

I have a subform in my Order form. when I put the same subform into my Invoice Report and make changes it affects the subform in my form. In my form I have the subform in blues. In the report I dont want the blue and change the background to white. When i open the order form back up the subform is white. It doesnt seem like that is happening on Ricks video. I am watching the Quote or Invoice video. did I miss a step somewhere? I was thinking maybe I needed to have a copy/paste of the subform so they dont affect each other. thanks in advance

	Richard Rost @Reply 11 months ago
Are you using the same subform object? If so, it might be pointing to the same ACTUAL form in your database. If you want them to look different, copy and paste OrderDetailF to OrderDetailForInvoiceReportF or something like that.

	Shallena Ayers OP @Reply 11 months ago
Yes, I was using the same detail subform for the form and for the report. I will remember to copy and paste the subform and give it a new name when using in my reports. I didnt see you doing that so I wasnt sure I needed to. Thank you for your response

	Richard Rost @Reply 11 months ago
Well, if you just copy the subform object (the control itself), it's going to point to the same form. So, if you want to change attributes on it and have it look different in one place to the other, then you have to make two separate objects, two actual forms in your navigation pane.

	Richard Rost @Reply 11 months ago
Alternatively, you could use the same subform object and just change its properties with a little VBA. Like if you wanted the color to be different based on where that subform appears, you could just look at the parent object. And I smell a video coming out of this, lol.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 10.

Next Unseen

New Feature: Comment Live View