basing one form on another

D

Desert Bear

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]))
 
L

Larry Linson

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
 
Top