saving data from combo box

[kwtmd]

I have a table called problems and a table called clients. I have created a relationship between these files. I am using a combo box in clients to access for quick entry problems from the problem table. The standard function in access seems to be to store the unique reference field relating back to the problem file. However, I want to store the actual problem. The reason is that when I later update or modify the problem list, I do not want it to change the client file problem field. How do I accomplish this? thanks.

 

[kwtmd]

confused

new to Access. how do I add an order by clause to ......."?

 

[kwtmd]

confused

How do I "add an order by clause to the rowsource...."?

 

[kwtmd]

thanks...

The RowSource is a query or if it isn't then you need to create a query, choose to sort by the text field, save the querydef. Then change the RowSource so that it points to the saved query rather than directly to a table.

thanks....