This works sort of

[Lou_Reed]

In the two files that I have attached the email mechanism seems to run. In fact it gets the person correct : "Peter Cushing". However when it
gets to the email address which should be : Peter Cushing@yahoo.com, it just gives me the Peter Cushing name again. That is a name not an email address.

Clearly in the line I have asked for an email address. As you can see in fmrEmail. Yet it gives me a name. it also gives me a number instead of an Branchhead name which I


ask for a few lines later. What is going on? I clearly asked for an email and got a name and I clearly asked for a Branchhead name and got a number.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

Okay, I think that I have the Branchhead problem fixed. I am not sure why it was even a problem since I used the ComboBox wizard. I know that seasoned MS Access designers, programmers do not, but I am not seasoned. I am also confused here somewhat. The record source for the frmEmail is qryPersonnelMeeting. That s what I first used as my source in creating the first Combo Box which did not wok.. However, in the second Combo Box, the one that I created that gave me the correct output, I used the Branchhead table not the query. It was there and it just seemed simpler.

The query is the source and the Branchhead table is part of the query, but it clearly is not the record source per se.

However, the query wizard did give the option of using the table so I did.
I am wondering if this is correct. It just seems something is wrong.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

I guess that I have the answer to the first part of the previous post, but not the second part. It just seems that the record source is not what is used, instead the Branchhad table is used. Of course, the Branchhead table is used in or is part of the query, but the Branchhead table was offered by the combo box wizard (as well as the qryPersonnelMeeting) so I just used it. The Branchhead table just seemed more direct which is why I used it.I am not sure if it should be used. It just seems redundant or as mathematicians might say degenerate.

Any help appreciated. Thanks in advance.


Respectfully,

Lou Reed

[andy49]

Did you sort out the email issue in this Lou?

[Lou_Reed]

Not yet, the email does work, but some the values that are put into the email are incorrect. I jump around a bit, if I am stuck on one thing move to another. Then come back the first when new info is known. Someone commented last week that my use of tables here would make the db too slow. That is why I a asking the question.

Any help appreciated.

Respectfully,


Lou Reed

[andy49]

I've got it so that when you select Peter Cushing you get his email address in the box. Same with the other data

1) Change the "querytosetemailaddressandnametogether" to include PersonnelID as the 3rd column. Rename the query as qryemailaddress

2) Remove the controlsource that you had for the combobox. You don't need it.

3) Change the rowsource to just be qryemailaddress from the drop down

3) add this code in the after_update event of cboFullname

Me.Filter = "[personnelID] = " & Me.cboFullname.Column(2)
Me.FilterOn = True

Let me know!!!