Show Query result in Form Header

[ixusss]

Hi all, hope you have help me with a project i am working on as I just started to learn Access. I have a table, Client, with Client ID | First Name | Last Name
And I have a query, Client Extended, with Client ID | Client Name
How can I show the Client Name with the matching Client ID in the Form Header when I open up a form?

Thanks a lot for you help.

 

[boblarson]

If your form is already bound to a recordset there are a couple of ways to do it. One way is to just create a subform and put it in the header (making sure to link the correct fields between the Master and Child).

 

[Wiz47]

If your form is already bound to a recordset there are a couple of ways to do it. One way is to just create a subform and put it in the header (making sure to link the correct fields between the Master and Child).

It seems to me that he is using his query as the recordsource. (maybe) But if he is, where is the field Client Name coming from? It doesn't match any field in the table.

 

[ixusss]

Sorry, I should have stated that in the query I also have
First Name | Last Name

Is there a way that I can put in a text box in the Form Header and edit the control source to achieve the result?
Thanks

 

[Wiz47]

Sorry, I should have stated that in the query I also have
First Name | Last Name

Is there a way that I can put in a text box in the Form Header and edit the control source to achieve the result?
Thanks

You can put a textbox in the header, then

=[First Name] & ", " & [Last Name]

* note: It's not a good idea to put a space in the fieldname. ClientFirstName and ClientLastName would be better.

 

[ixusss]

Thanks a lot.

Took me a lot of time and I couldn't figure it out. Gee.. seems pretty simple now with the method you suggested. And thanks for the advise.