Ok No luck there can i force a text box to show Clients Name and make the
combo box not visible?
Bob, this is making NO SENSE AT ALL.
Of what earthly good would a combo box be if you couldn't see it!??
There are forms in every real Access database ever built using combo boxes to
show data. There's something you're not telling us, or not doing correctly.
It's like pulling teeth to get any details out of you. This is a *very simple
problem* and somehow we've spent a month making it into a monstrously
difficult one.
Rereading the messages, you posted:
ClientID (Number)
LastName (Text)
FirstName (Text)
using your own fieldnames.
2. What Query did you use for the rowsource? Please open the query in SQL
view
and copy and paste the entire SQL to a message here.
SELECT tblOwnerInf
![Er... what? o_O o_O](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wnerID,
IIf(IsNull(tblOwnerInf
![Er... what? o_O o_O](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wnerLastName),'',tblOwnerInf
![Er... what? o_O o_O](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wnerLastName & ', ')
& " " &
IIf(IsNull(tblOwnerInf
![Er... what? o_O o_O](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wnerFirstName),'',tblOwnerInf
![Er... what? o_O o_O](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wnerFirstName) AS
ClientName, tblOwnerInf
![Er... what? o_O o_O](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wnerFirstName, tblOwnerInf
![Er... what? o_O o_O](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wnerLastName,
tblOwnerInfo.Status
FROM tblOwnerInfo
ORDER BY
IIf(IsNull(tblOwnerInf
![Er... what? o_O o_O](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wnerLastName),'',tblOwnerInf
![Er... what? o_O o_O](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wnerLastName & ', ')
& " " &
IIf(IsNull(tblOwnerInf
![Er... what? o_O o_O](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wnerFirstName),'',tblOwnerInf
![Er... what? o_O o_O](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wnerFirstName);
So you have *some* table with fields named ClientID, LastName and FirstName.
YOu have some *OTHER* table with fields OwnerID, OwnerLastName and
OwnerFirstName.
Are these two redundant tables with the same data?
Does the first table contain Dobbie's first and last name, and the other table
only the last name?
Are you posting incorrect and misleading information about your database?
Do you understand what's even IN your database?????