Recent content by KPMS

I've found another way, if the table the combo box gets its data from only has one field (the data field, no key field), then it works perfectly.

Thanks, it works fine, except it doesn't let you see what's actually in the column you searched for in the combo box, it just brings up what's in column 0. I wonder why it all of a sudden stopped working? I also wonder if it only effects Access97?

I've had exactly the same problem, in a previous database it worked perfectly, but now whenever I go back to that database it doesn't work either. It's like Access has just switched off being able to do that or something. I'm using Access 97, which version are you using?

I'm having some trouble with queries gathering information from Cobo boxes. I've set up a form to launch a query, in it there is a combo box(combo6) and a search button. The form is called "FrmGenericq". Below is the SQL for the Query: SELECT TabItem.Type, TabItem.Location...

I've been given a database to create and I'm having a few problems with some of the required queries, this one in particular. What I need to do is to create a query that lists the number of people wanting a particular option on a course, but there are multiple options for this particular field...

I've been given a database to create and I'm having a few problems with some of the required queries, this one in particular. What I need to do is to create a query that lists the number of people wanting a particular option on a course, but there are multiple options for this particular field...