Recent content by ataylo27

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

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...

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...

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?

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...

Yes - that was it! Thanks again!

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...

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...

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.

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?

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...

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...

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...