basing one form on another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have just added a new form, frmPastEval, as a popup to frmEvaluatio
I would like frmPastEval to show the name selected in the combo box on frmEvaluation
How can I do this

Currently frmPastEval is based on the following query and it is coming up blank

SELECT tblPeople.peoID, tblPeople.peoFullName, tblEval.*, tblPeople.peoPA
FROM tblPeople INNER JOIN tblEval ON tblPeople.peoID = tblEval.peoI
WHERE (((tblPeople.peoID)=[Forms]![frmEvaluation]![cboEvalSelectName]))
 
Is the select statement you describe the RecordSource of frmPastEval, or is
it created in code? If the latter, then you'll need some quote marks
strategically placed.

BTW, "names" aren't really a good way to identify people... you don't have
to have a very big group, all things considered, to find two people with the
same name.

Larry Linson
Microsoft Access MVP
 
Back
Top