Recent content by kdw3

Hi, I think I have worked it out. I believe it has to do with the 'FROM' clause. My assumption is that because there are 4 'AND' statements in there which all need to be satisfied to return a record. Since there is never a combination like that it returns 0 records. If you would still like to...

Thanks for the reply. I don't think I am trying to achieve what you are describing. I have attached the SQL below (not enough posts to insert picture) which should clarify it. If someone could tell me the reason this is not returning any records, I would be very intersted. For information, when...

Hi All, I am fast approaching my wits end :banghead:. I have a very simple query to run but for whatever reason, I am not getting the results that I want. I am working with 2 tables. Table_A contains a field (Field_Status) that has 10+ values which I want to map onto a smaller set of values...

Hi, Thanks a lot for your help. Its a very useful link. Cheers

Hi. Yes, thats exactly what I want to do. The form is just simply to edit a customers details if the need arises, but as I mentioned, I cant get it to stay on the right record, it always jumps forward one when the combobox loses focus. Thanks

Hi there, I'm sure this is a stupid question but here goes. I have a form that contains bound textboxes to a table in the db. What I want to be able to do is to have a combobox which I use to select the customers name, have it fill the textboxes with the right info so that I can edit the...