Recent content by ataylo27

  1. A

    Using Three Combo Boxes to Apply Progressive Filter on Subform

    Can't wait to give this look-see! Thank you!
  2. A

    Using Three Combo Boxes to Apply Progressive Filter on Subform

    I have a form with three combo boxes. I want the values selected in these boxes to filter the records returned in an attached subform. The first combo, cboSelect Tester, has the following AfterUpdate code and works perfectly: Private Sub cboSelectTester_AfterUpdate() If Not...
  3. A

    Split Database - Accessing the Front End Via Citrix

    I guess I'm confused about how to get them their own front-end copy without having to actually place it on their local drive. Where you said you used C:\FolderName\UserName -- are you meaning that you placed a copy for each user locally, or did you place it in their Citrix profile? I've got...
  4. A

    Split Database - Accessing the Front End Via Citrix

    I mean front-end! Sorry! So, then, can they all access the SAME front-end file stored on a network drive, using Access through Citrix?
  5. A

    Split Database - Accessing the Front End Via Citrix

    I have a database application, split into a front-end (ACCDE) and a back-end (ACCDB) in Access 2013. The back-end contains ONLY data tables. The front-end contains everything else. What I've read about this scenario indicates EACH user should have their OWN copy of the back-end. My problem...
  6. A

    Requery AfterUpdate in Subform Wipes Out Previous Selections

    Yes - that was it! Thanks again!
  7. A

    Requery AfterUpdate in Subform Wipes Out Previous Selections

    One last teensy issue .... and I've uploaded a new copy of the DB to demonstrate. It has to do with the Error Code field. This subform combo box should flex based on the selection of QC or QR from the MAIN form. I'm using an IIf statement in the underlying rowsource query and it appears to...
  8. A

    Requery AfterUpdate in Subform Wipes Out Previous Selections

    That was IT! I literally found it myself two minutes before I received notification of your reply! I got up this morning and decided to recreate everything from scratch - that's how I found it -- AND that's where I added the missing popproduct FormLoad event! Sometimes, you just have to...
  9. A

    Requery AfterUpdate in Subform Wipes Out Previous Selections

    Many thanks! I hope it's a quick fix. I think I'm close - just missing something simple. However, admittedly, with this particular thing, I'm a little out of my league.
  10. A

    Requery AfterUpdate in Subform Wipes Out Previous Selections

    Two steps forward, one step back. Seems like I'm getting closer, thanks to your help! But, it's still not quite right. Would you be willing/able to take a look at my DB?
  11. A

    Requery AfterUpdate in Subform Wipes Out Previous Selections

    Thank you - that helped considerably. Now, in this scenario, my Facility = your Colour. I think that means my Unit - your Product? My row source for Unit is: SELECT tblFacilityUnit.UnitID, tblUnits.UnitName, tblFacilityUnit.FacilityID FROM tblUnits INNER JOIN tblFacilityUnit ON...
  12. A

    Requery AfterUpdate in Subform Wipes Out Previous Selections

    I am using a datasheet data entry subform. I have reviewed the information/demo database to which you directed me, but I'm having some real difficulty figuring it out. Your example includes some notes, but, honestly, I don't mind being spoken to like I'm a three-year old, if that's what it...
  13. A

    Requery AfterUpdate in Subform Wipes Out Previous Selections

    I am using Access 2013. I have two combo boxes in a subform. The first combo box, Facility, limits the contents of the second combo box, Unit, using an AfterUpdate macro that simply employs the requery command and references the Unit control. The record source for the Unit combo box contains a...
Back
Top Bottom