Search results

Thanks! Don't worry about it, I got it working. One of my variables was wrong in the SQL statement! :)

Hey Ct, If you look at the Reviews table. I have two reviews of Johnson, and two reviews of Smith. Currently, they each have one Lead Review, and one Other Review. If possible, it would be nice to enforce a way that if there is already one Lead Review of Mr. Johnson, the second review of him...

Actually must be a different issue. Drop down only ever shows one row even if there should be multiple.

Moving back to my real DB, code is adjusted but getting the blank box in combo box again? SELECT Candidates.ID, Candidates.CandidateDisplayName FROM Candidates INNER JOIN CandidateIdentified ON Candidates.ID = CandidateIdentified.CandidateIdentifiedCandidate WHERE...

Yay!! This worked! You are awesome! :) :) :) Yes other slots would work the same way. Only thing I would change if it was easy would be to ensure the same individual is not in more than one slot.

Ok got it again. Requery goes on Subform1 ON CURRENT as such: Me.Parent![Subform2].Requery Subform2 set data as follows: Link Master Fields: [Subform1].Form![Subform1ID] Link Child Fields: [Subform2ID]

Darnit, I broke it again and can't recall what I did. I will record it this time! Arg. So SubForm1 points to Combo Box successfully. Subform2 doesn't update when I click a record in Subform1. Not sure if it's the requery or the Child/Parent fields.

Sorry about that, I got lazy on my test DB and didn't quite mirror the table structure of my actual database. This update is much closer. I tried two different SQL on the second drop down, both seem to do the same thing. The number of lines available in the second combo is correct, but they are...

Hi CT! Thanks for your help! Here is a quick mockup. In the attached DB, if you look at the Reviews table, I'd like a way to make it impossible that more than one review of Johnson or Smith, in this case, can also be marked as Lead Reviewer. This is because we will weight the scores later on...

Thank you to you both for the replies! CJ, After my post last night I got further along, first drop down works (mostly) but the second one is always blank. I tried your simpler approach, but got the same result. Here is my practice file if anyone would be willing to take a look. I am doing my...

Review type is a choice column (field) in the Reviews Table that must be filled for each review (ie. each record).

Hi guys, I have read a very good guide here http://www.fontstuff.com/access/acctut10.htm I think I fall into scenario 2. I have tried putting this code into the AFTER UPDATE event of the "parent" combo box: Private Sub Position_AfterUpdate() On Error Resume Next Slot1.RowSource =...

Hi, I have a table that houses employee evaluations. There can multiple reviews per employee (from manager, colleagues, etc.) but I only want ONE per person to be able to be identified as Lead Reviewer. This is in it's own choice field, called Review Type. How would I do this?

Got it working, thanks!!

I believe I am following you. FK = Foreign Key correct? Can I not use Primary key? That may be my problem. I tried following your steps but nothing is getting written to the textbox, so I must have that step wrong somehow. On the Form's "On Current" I did: =[Text87]=[Assessments...

Basically I wanted this form to be a one-stop-shop for the user. I had hoped that they would only use the subform to actually score the ten items listed. As such, I had locked down (disabled) the first column so it could not be edited, and records could not be added or deleted - simply because...

Hi guys, I have a standard duplicate button on my form which works well. However, this form has a subform. Is there any way to create another button on the page that would populate the subform with "placeholder" data. This data would always be the same 10 records and i'd want the score to...

Hi guys, I have a form which currently allows me to pick from a Combo Box from a list of candidates. When selected, if they have a record in another table, it will show those records in the subform. Problem is that subform has LOTS of fields, some of it is tombstone data, the other is...

Thanks, I will!

Hi again Plog, I need your help. I took your advice and split off some of the tables. I'm trying to get a lookup to work, and I think it should "just work" if the relationships are correct, but maybe I'm wrong? Tables concerned are: -Candidate Table -Candidate Identified Table (essentially an...