Search results

Uncle Gizmo, thank you for your time and effort and trying to sort out my problem. I very much appreciate it. I guess I need to redesign my two forms. Not entirely sure how but will try and figure it out. Thank you again.

Thank you for the video. I was only able to look at it once (I'm at work at the moment). From what I'm understanding is that you think I should only have one form? If so, I didn't understand how the user will be able to filter to records that only pertain to them?

Uncle Gizmo I totally understand and look forward to your reply tomorrow. Or anyone else's for that matter. Thank you.

Okay, I've attached the db. Open form "Switchboard" (again I'd do away with all the subtabs and just leave the "carline" and "general forms" tab)that's where I'd want the two combos of Customer and PKGEngineer and a button to open the other form to the filtered records selected from the two...

Ha! Well I really appreciate you staying up to help me with this.

Again, I’m too slow on my response. You are really fast! Okay so replying to two post: Post #16 reply: Right now the way I have it set up, with the different tabs for different car lines is not the way it will be once I have it with just the two combos. I have it set up that way bc I was...

When the "Program Customer Model Year form" (sorry for horrible naming convention) is opened from the navigation pane, it opens to the first record from that table "Program Customer ModelYear". And the subform displays all records associated with those combos (with Program, Customer and Model...

The more I think about it, both combo's should not be left empty. They whole point of doing this is to filter the records to only show the one's selected by one or both combos.

Sorry took to long to respond to your other post and didn't see post #11. Never thought of all combos empty. One or both should always be selected or there is use going to the other form. But I guess if they are left empty then all record would be shown.

Yes...if I'm understanding you correctly. So on the Switchboard you would select from two combo boxes and they would correspond to the combo’s on the form with the subform. Sorry if I’m repeating myself, just want to make sure I’m explaining this properly.

Again sorry for cross posting. This is the original post and this is a link to the cross post. And Uncle Gizmo I forgot to thank you for replying to my post. Okay. The Switchboard is a separate form. And the subform is in datasheet view. I've attached screenshots to help explain better...

Sorry for the cross post. I did not know. This is the original post.

Yes, it's a subform created by subform/subreport control and placed in the detail section of another form.

I need to open up a form to specific records in its subform based on user input from combo boxes (Customer and/or PKGEngineer). The two combo boxes are on a switchboard. How can this be done? Thank you. Using: Win 7 Access 2010

Hi Gina, I hope everything is okay and that I didn't offend you in anyway. Would you still be able to help me incorporate the code to add the date filters?

Okay, well thank you for your time I appreciate it.

Oh, was I looking at the wrong Property field or do you think it might work?

Oh, Okay. Way above my head then. Just curious: When I open the subform in datasheet view in the property sheet under the Format tab there is a property named "Scroll Bar Align". It's set to System but there are options for Left or Right. But when ever I select Left or right it does not let...

vbaInet thank you for your reply. I'm not sure what this means (which sounds like the less complicated way to go): fyi: I'm not to versed in coding if that's what API involves.

I have a subform that’s in datasheet view, is there a way to align the vertical scroll bar to the left side? Using: Win 7 Access 2010