Search results

I remember reading about the columns in these fora. The second column does get populated. The code works just fine when there is only Her2 in the Immunostains field. But when there are other values along with Her2 it runs just the else part of the code. So I suppose it is either the operator...

I did as you suggested. The tooltip message is Me.Immunostains.Column(1)=Null Does that help in any way? Sorry, I am an absolute novice and thanks again for taking the trouble to reply. On a positive note I learnt how to introduce a break in a code!

Tried what you suggested. Still the same result. I have also tried using the IN operator as follows: If me.Immunostains.column (1) In (*,"Her2",*) Then But it gives a compile error for that line. (Expected Then or Go to)

Thank you very much for your response old man Devin. I have tried changing that line to both If Immunostains.Column(1) Like "*Her2*" Then and If me.Immunostains.Column(1) like "*Her2*" Then The problem still persists. I guess I will have to stick with two command buttons.

Firstly, I am a medic and not a programmer. I use access to create simple databases for my workplace. So please bear with me if my question is stupid or does not make any sense. I have a single table data base (I know. My use of access is that basic) with a single column multivalue field...

I am a medic and use access in a very simple way for some database management in the hospital. I have lurked through the fora many times and learnt a lot and thought it is time I joined.