I
Ian
I have a form with clientID based on a query.
I'd like a textbox that will pull the clients name from the Tbl_Client
(based on the clientID).
I created a small query with the SQL statement:
SELECT Tbl_Client.ClientID, [ClientLN] & ", " & [ClientFN] AS ClientName
FROM Tbl_Client
WHERE (((Tbl_Client.ClientID)=[forms].[frm_apptdetail].[clientid]));
Then a textbox for the form (frm_apptdetail) with the control source set to:
=[Qry_NameforApptDetail]![ClientName]
but all I get in the textbox is #Name?
Anyidea what I've done wrong or is there a more elegant way for the textbox
to pull the info?
Thanks Ian.
I'd like a textbox that will pull the clients name from the Tbl_Client
(based on the clientID).
I created a small query with the SQL statement:
SELECT Tbl_Client.ClientID, [ClientLN] & ", " & [ClientFN] AS ClientName
FROM Tbl_Client
WHERE (((Tbl_Client.ClientID)=[forms].[frm_apptdetail].[clientid]));
Then a textbox for the form (frm_apptdetail) with the control source set to:
=[Qry_NameforApptDetail]![ClientName]
but all I get in the textbox is #Name?
Anyidea what I've done wrong or is there a more elegant way for the textbox
to pull the info?
Thanks Ian.