SQL code error

[Lou_Reed]

Okay, I think that I know what happened. The line of code:

 Me.cboEmployeeName.Value = ""

Sets the value of cboEmployeeName.Value actually Me.cboEmployeeName.Value to nothing and that is why strWho comes out Null in the line strWho = Me.cboEmployeeName.Column(1)

I cannot explain the second line varTo = Me.cboEmployeeName.Column(2). It only happens with the strWho line (previuos to it) is commented out. I just do not know why it sets varTo to empty. I believe that Null and empty are not the same. So something is going on here.

Is this correct?

Respectfully,

Lou Reed

[Lou_Reed]

I am unsure as to what post you are referring to. I have questions about this code, but the code problem is not anything to do with

strMeetingID = me.txtMeetingID2

is over with.

Just what posts are you referring to?

Respectfully,

Lou Reed

[rpeare]

the line of code is in the screenshots you posted in your last one with attached files. I am not currently able to open your version of access on my computer so I was going by the screen shots you provided.

[Lou_Reed]

Okay, I am talking about the two lines that set the value of strWho and varTo. Those are the lines that are perplexing to me.

As I said in an earlier post the reason that strWho was set to Null is that

 Me.cboEmployeeName.Value = ""

Sets them to null. In other words this line sets everything to Null (I think) and so the line pointed out above make strWho equal to Null.

I am asking if this is why strWho is Null. I do not know. I am just asking.

The value of

strMeetingID

is of no concern to me now. The place where those two variable strWho and varTo get values is of concern to me.

Anyway, thanks for your help.

Respectfully,


Lou Reed

[June7]

Yes, that is why strWho and strBranchhead are empty string (not Null). The combobox is set to empty string in its AfterUpdate event.

Don't reference the combobox. Reference textbox or field: strWho = Me.txtName


cboEmployeeName is to select an employee to send address to. strBranchHead is supposed to be who the email is from. Makes no sense to reference the same control for both. Do you need another combobox to allow selection of branch head name?


cboEmployeeName is set for 4 columns but it has only 3 fields (PersonnelID, FullName, emailaddress) in its RowSource. Doesn't hurt anything.