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
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 AyersOP
@Reply 16 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
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.
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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 10.
