Replies

Please clarify, Peter.
Where does the combobox fit in? I don

Stephan,
The reply to your

Excuse my bad spelling. The trick is to spell trigger the correct way.

I suggest you create a table having your files and descriptions.
Use the table as the rowsource for a multiselect listbox on your form and include a button to fire off the e-mail process. Look at Helen Feddema’s Home Page http://www.helenfeddema.com/ for help on sending e-mails.

Don’ t worry – the query will be run once only for each SiteInfo record in your table. The form’s AfterInsert event will be trickered only after a new record has been added.

Since you are using a tab control it should not cause you a lot of trouble to do what you aim to do.
Selecting the page having your subform will tricker the AfterInsert event for the form when you have typed your new record..
Hence, all you have to do is to use the following code for your form

Q1: I assume that the button_Click event is in VBA code. If true look at the code in the class form and insert a line like this next to the DoCmd.OpenQuery stmt:
[sbfSiteReviewCriteria].Requery
Where sbfSiteReviewCriteria is the name on the subform control. To find the name: select the subform control with the form in design mode and look for the Name property.

Q2: If you are not used to do VBA coding, I think you best stick to what you have and ensure that the new record is saved before the query is run. You cannot link new records in another table to the new SiteInfo record until it has been saved. To save the record you may insert the following code line in button_Click event before the Docmd.OpenQuery stmt:
DoCmd.Runcommand acCmdSaveRecord

If this is rubbish to you or I did not seem to understand your problem, yell!

It is not clear to me what you would like to do.

If you want to extract each comma separated value you might have a look at: http://www.mvps.org/access/strings/str0003.htm

Surely you can write your condition checking in separate code. How did you do it, and what variable was not available?

Kan nogen anbefale et godt spansk kursus? = Can anyone recommend a good spanish tutorial? (Just joking!)

Exactly my point.

As far as I know you can’t change the backcolor for just the selected row – only for all of the listbox.

I can’t imagine why you would change autocorrect options in VBA at startup.

Anyhow, you can use the SetOption method of the Application object to set options.
Application.SetOption optionname, setting

Look for help on Application obejct and SetOption.

You may use:

DoCmd.RunCommand acCmdPageSetup

A small hint/correction to my prev. reply.
Use the Load event. Not the Open event, since this will not execute if the form is already open.