Recent content by 57otto

dear Databasednr, the reason why the concatenation is not working, is because "Section" is a reserved word in Access. I had the same problem when I used "Name". Replace Section by Section1, and you will see that it is working. That's also the reason, why the example of ANsentry is working...

I'm using the dutch version of access. This could be the reason. The best workaround is using the eval function. Thanks for answering otto

Excuse me, I forgot the attachments. otto

dear RV, Thank you for continuing the discussion. I see it is not so simple to explain things by mail. Like you said, nothing wrong with the query itself. I first take the form Form1. For both comboxes I take the first value in the list. This is not important. Then I run Q_form1a. The result...

Open Form1 Then have a careful look at queries Q_form1a and Q_form1b and you will see what I mean. I had expected that the value of the combobox would have been the value in the combobox display. I'm really curious where this comes from. otto

Sorry, I don't think I'm a beginner in Access. I'm quite used to create Access applications since more than 5 years and I have a university degree in computer science. The sites you are referring to, are well known to me. If you say "this is how a combobox works", then I would like to show me...

I have been confronted with a strange fenomenon in comboboxes. I'm working with access2000. I put a simple combobox in a form. The row source of the combobox is a table and the first field of this table is a number. The bound column is 1. When I select a record in the combobox, that number...