Query with combo box

[Guest]

I have created a select query where I'm linking two tables based on client
ID. In the main table Client ID is a combo box. In the Client Info table,
Client ID is a text field. Both Client IDs fields are text. However the query
doesn't give me Client Name from Client Info tbl. Any ideas why and how to
fix it? Is it because of Combo box?

 

[Guest]

Please post the SQL.

However I'm betting that you are talking abut a LookUp field as the combo
box the table. In that case, what you see is not what you get. This is one of
the many reasons to avoid LookUp tables. Check the row source and bound
column in the LookUp then check the lookup table to see the actual data to
query on.

 

[Guest]

Here is SQL:
SELECT [Evidence Misuse].[Acct Date], [Evidence Misuse].LOB, [Evidence
Misuse].[Client ID], [Client RCA Assignment].[Client Name], [Evidence Misuse
- Project List].[Project ID], [Evidence Misuse - Project List].[CAS ID],
[Evidence Misuse].Contact, [Evidence Misuse].[Attesting Associate], [Evidence
Misuse].[Misuse Violations], [Evidence Misuse].Comments, [Evidence Misuse].RCA
FROM ([Evidence Misuse] INNER JOIN [Evidence Misuse - Project List] ON
[Evidence Misuse].EntryID = [Evidence Misuse - Project List].[Entry ID])
INNER JOIN [Client RCA Assignment] ON [Evidence Misuse].[Client ID] = [Client
RCA Assignment].[Client ID]
WHERE ((([Evidence Misuse].[Acct Date])=[Enter Accounting Date]));

Yes it is Lookup with combo box. I need the look up combo box for a data
entry form.

 

[Guest]

The SQL looks OK. You need to look behind the table in design view and check
out the lookup. Then you should see what it really linking the two tables
together.

Were I you, I'd get rid of the combo box at the table level and also all
other lookups. Then in your form you can either (1) create your own combo
box, or (2) use a form/subform combination to link the tables together.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Here is SQL:
SELECT [Evidence Misuse].[Acct Date], [Evidence Misuse].LOB, [Evidence
Misuse].[Client ID], [Client RCA Assignment].[Client Name], [Evidence Misuse
- Project List].[Project ID], [Evidence Misuse - Project List].[CAS ID],
[Evidence Misuse].Contact, [Evidence Misuse].[Attesting Associate], [Evidence
Misuse].[Misuse Violations], [Evidence Misuse].Comments, [Evidence Misuse].RCA
FROM ([Evidence Misuse] INNER JOIN [Evidence Misuse - Project List] ON
[Evidence Misuse].EntryID = [Evidence Misuse - Project List].[Entry ID])
INNER JOIN [Client RCA Assignment] ON [Evidence Misuse].[Client ID] = [Client
RCA Assignment].[Client ID]
WHERE ((([Evidence Misuse].[Acct Date])=[Enter Accounting Date]));

Yes it is Lookup with combo box. I need the look up combo box for a data
entry form.

Please post the SQL.

However I'm betting that you are talking abut a LookUp field as the combo
box the table. In that case, what you see is not what you get. This is one of
the many reasons to avoid LookUp tables. Check the row source and bound
column in the LookUp then check the lookup table to see the actual data to
query on.