Parameter Query in a form

[rhett7660]

Bob..

I hope I did what you suggested... I created a query with the fields I wanted to combine and then created another query with that query with the other fields, here is th sql for that:

SELECT tblInvestigator.InvestigatorID AS tblInvestigator_InvestigatorID, tblInvestigator.InvLName, tblInvestigator.InvFName, tblInvestigator.EmpNumber, tblInvestigator.Rank, [InvLName] & ", " & [InvFName] AS InvName, qryAppFosCombo.AppFosCombo
FROM tblInvestigator INNER JOIN qryAppFosCombo ON tblInvestigator.InvestigatorID = qryAppFosCombo.InvestigatorID
WHERE (((qryAppFosCombo.AppFosCombo)=[Forms]![frmReports]![cboFOS]));

I also did the following, created a field within the original query and used the following code:

SELECT qryAppandFOS2.FosApp, [FosApp] AS FOSName FROM qryAppandFOS2;

Neither of them are working..... I am not getting any errors on the second one, but I am not getting the combo box populated either.

R~

 

[Krava]

Hi, Rheet!

Sorry, I just join you conversation in late point, but I have noticed one thing that is quite important for me at your problem: The row source of the combo box on the form is the table. The bound column is No.1 (see in properties) and it is ID (number). So your selection in Combo box does not retur the text (e.g. "Test"), but the ID (1). I only checked the first Query and you use this combo box value (1) for selection of the table field that is string- it expects the value "Test" isn't it?
Maybe I understand something wrong.

Krava

 

[rhett7660]

Krava..

Correct... I fixed that so now it shows the text and not the ID number.

Thanks
R~

 

[rhett7660]

Bob..

Can you see what I am doing wrong? I have tried several different ways and I am still haven't been able to get it to work.

I am trying to get the last name of the FOS and the last name of the applicant to show up like you did for the investigaters name.....


R~