Subform No Duplicates 1

[Elvis72]

I have a subform here:

SELECT TblProjectInformation.ProjectID, TblStaffRequirements.Title, TblProjectInformation.[Title ID], TblProjectInformation.WorkerID, TblProjectInformation.[Job/ProposalNo], TblProjectInformation.[Requisition No], TblProjectInformation.[Mobilization Date], TblProjectInformation.[Demobilization Date], TblProjectInformation.[HR Classification], TblResumes.[First Name], TblResumes.[Last Name], TblResumes.[Cell Phone], TblResumes.Email, TblResumes.[Resume Link] FROM TblResumes INNER JOIN (TblStaffRequirements INNER JOIN TblProjectInformation ON TblStaffRequirements.[Title ID]=TblProjectInformation.[Title ID]) ON TblResumes.WorkerID=TblProjectInformation.WorkerID;

Until I put WorkerID as a No Duplicates field in my TblProjectInformation the form worked fine except it allowed the same worker to be entered multiple times in the same project.

NOW...when I use the drop down for WorkerID to select the person the First and Last Name do not Auto-Populate, BUT when I go back in its there?

Can't figure out what I'm doing wrong???

Thanks so much for your help!~

 

[TheAceMan1]

How are ya Elvis72 . . .

You say you added [blue]WorkerID[/blue] to prevent duplicates, yet [purple]your able to add the same worker multiple times.[/purple] Ya got me there!

As far as the combobox is concerned, have you tried to requery the combobox?

[blue]   Me![[purple][B][I]ComboboxName[/I][/B][/purple]].Requery[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Elvis72]

Good Morning Ace!~

Before I placed the no duplicates criteria on the WorkerID field it did allow duplicates but it also auto-populated the First and Last Name fields.

Well, I have tried putting it in AfterUpdate and OnChange with nooooo success?

But if I have the form open and hit Shift F9 it does it...but can't get it to do it after I make a selection in the Combobox?

 

[Elvis72]

OK...was looking through posts about requery...

Would I not want to requery the First and Last Name fields instead of the combobox?