Field changes stopp queries...?

[AlanGNW]

Relatively new to Access - but not completely incompetent

I've been building a relatively simple Access (2000) database. And made the mistake of putting free text into a couple of fields at set up and then changing them later to combo boxes drawing on other tables (i.e. a client list and a list of sales contacts. In doing this I now find that mt queries using these fields dont work.. also when using find this also does not work - however it does appear to work when using numbers? How can I fix it to see the fields in text again rather than the record ID's on the secondary tables?

Thanks in advance for your help!

 

[SQL_Hell]

change the bound column on your combo box to 2

 

[AlanGNW]

Tables?

Would that be on both tables?

What exactly does this do?

Thanks for the help...

A

 

[SQL_Hell]

ummm not sure what you mean by both tables.....thought we were talking about combo boxes

 

[AlanGNW]

My mistake...!

The problem seems to be the link in two combo boxes which draw on other tables. For instance the main table draws on a list of customer names from a 'customer' database for the combo box.... The queries are only responding if I put in the number of the record ID rather than the names when asked. If I put the name in they fail.

Sorry - I could have been clearer...

A

 

[AlanGNW]

Tried '2'

Tried 2 in the bound column as you suggested - but still getting the same result...

 

[SQL_Hell]

ok

post the query behind the combo box so I can be sure, this is in properties of the combo box

 

[AlanGNW]

The two field casing me grief are...

SELECT Clients.[Record number], Clients.Company FROM Clients;

SELECT [Sales contact].[Record number], [Sales contact].[Sales contact] FROM [Sales contact];

The criteria within the querie is...
[Client name: example - XXX]

 

[SQL_Hell]

ok I think I got it,

at the moment it is concentrating on bound column 1 which in you're query is the 'Record number'

If I understand correctly you want it to show bound column 2 which is
'Sales contact'.

so

change the bound column in your combo box to 2, then set the column 1's width to 0.

this should fix it

 

[AlanGNW]

No result

Sadly no result. Still responding to the number rather than the text....

 

[AlanGNW]

Solved it thanks. The problem lay in the fields of forms and reports. Although I had the table right - the forms were placing in the wrong column of the secondary table. Thanks for the help!