Are the fields in the underlying Record Source of your report (Table / Query)?
Have you added the field(s) to the Report?

All the information for the report comes from my ProjectT.  The names in the Comboboxes come from ProjectManagerFLQ.  The add Existing Fields tab only allow me to use a Table and not a query, to bring in fields to the report.  i.e. show all tables at the top.

You will need to build a Query to bring together the fields from ProjectT and the fields from ProjectManagerFLQ so they can be used in your Report. Base your Report off of this new Query (make it the Record Source).

Thanks Kevin i will give this ago, will i have to rebuild the report again using the new source? It is quite a big report (3 pages), or will it see the fields as they have the same name?

Kind regards

After you have built your Query, open the Property Sheet for the Report. On the Data tab change the Record Source to the new Query.

Having read you last message i have realized the report source is ProjectCurrentQ, criteria [Forms]![ProjectInputF]![ProjectID], which gets its source from ProjectT.  I am not sure how i would link ProjectManagerFLQ and PrincipalDesignerFLQ to ProjectCurrentQ.  Might be easier to just delete the comboboxes?

You can always use DLookup() to retrieve first name and last name.  It may slow down the report, but if it's only 3 pages (not a big report at all in terms of pages), it may be okay.

Hi
I am trying to use the DLOOKUP function and have watched the video (with the phone numbers).  I have set up the combobox which shows the initials and First Name and Last Name (concatenation), from a query ProjectMangerFLQ.  I have then set up a text box, with the following DLOOKUP to retrieve the combine name =DLOOKUP("FL","ProjectManagerFLQ","PMID=&"ProjectManagerCombo).  When run this then generates a flashing #Error in the form.

Your ampersand (&) should be outside the quotes.

=DLOOKUP("FL","ProjectManagerFLQ","PMID=" & ProjectManagerCombo)

Apologies it is, i have typed it wrong.

On closer inspection of your first image PMID appears to have a space in it. When you refer to the field in your DLookup there is no space. I would get rid of the space. It will make things easier going forward.

Sorted, PM ID is actually the caption, the Field name was ProjectManagerID.  I have updated and all works, thank you for the help.

This has now created another problem, how do i get the information from the textBox ProjectManagerFL into my report, which gets its information from ProjectCurrentQ, and then ClientT?  ProjectManager is a Field in ClientT, but ProjectManagerFL is not.

Hi
I have looked at this some more, and done some thinking, I have gone back to my backup and kept the original Field ProjectManager and put the DLOOKUP() in this box on the form.  The problem I have is that the Control source is now the DLOOKUP(), and so dose not save the result of the DLOOKUP() in the ProjectT in the Field ProjectManager, to then show in the report.  The DLOOKUP() result shows on the form OK.
Question how do I get the result of the DLOOKUP() to be saved in the Table, Field - ProjectManager, for that Record?

I have solved this with the AfterEvent function, thank you for letting me sound things out!