Replies

It worked perfectly! I really appreciate it.

Charlotte and Rupert:

Thanks for your suggestions — I just realized that I could have easily used the Tab Control to switch between Airline and NonAirline forms and setting up Parent/Child relationship between Primary Key and Foreign Key. This was simple solution that I didn’t think of earlier! grin.

Charlotte,

Both forms are not based on same table. The frmAirline and frmNonAirline forms are based on their own tables called tblAirline and tblNonAirline.

Therefore, if I wanted to store flight information for a participant, I need to store participant ID in the foreign key field in tblAirline.

I’m completely new to VBA. Can you please help me figure out the syntax for using OpenArgs? The line I created only comes up with a Null value.

Thanks.

Unfortunately, I cannot set up my table to do such because I have approximately 10 different communication preferences. I certainly don’t want to set up “Com Pref 1, 2, 3” etc…So, I created a many to many relationship between Participant and Comm. Pref table.

Smart Access didn’t have what I needed. I’m attaching a snapshot of the report that I’m having problems with. If you check out camper named Clarice Thomas, you will see two blank rows after the first row with her name. In that column named “Comm Pref” you will see two additional comm pref. that is under Clarice’s name. I want those to be concantated with the first row.

Brent

Thanks for your advice. I’ll try looking up AutoTextList in this forum.

By the way, the reason we need the form fields are due to blind users. They need a way to tab their way through the fax cover.

Brent

Shane,

Thanks for your suggestion. My friend also pointed out that my logic was flawed — I can’t use If…Then in order to perform this anyway grin.

Yeah, my form get closed after I open the report and after you suggested the visible property, I realized that that was an alternative method that I could have used.

After my friend pointed this out, I used Forms!!.setfocus command which did the trick.

Actually, the requery method works fine. What I really wanted was to close the “add new name” form and have the new name automatically show up in the combo box in order to look up its records.

Right now, how my forms work would be that the data entry person types in the name, if not in the list then “Add New Name” dialog box opens. the name of person gets automatically added to First and Last name fields. Data Entry person only needs to enter address, phone number and Email address and then click “close” button. The “Add New Name” form closes, and the Application form reopens. The Data Entry person now has to type in the name that she just had added to the New Name form.

I was looking for a way of automatically filling in the Name field in the Application form so that the Data Entry person doesn’t have to type the name again.

I’m not sure where do you put that line of code? Should it be placed inside the command button that closes the form and requeries the main form?

Also, the rowsource is set up in a such way that it combines last name and first name into one column by using Name:[LastName]&”, “&[FirstName].

Thanks to you all for your help! I really appreciate it.

I missed a question of yours…It is perfectly fine to create new contact before adding it to the distribution list. I believe that’s the only way to get the distribution list set up anyway?

Rory, here’s my answers to your questions.

1. The distribution list will be located in the Contacts folder.

2. I didn’t realize that I could store names and Email addresses in the database and programatically add them to the distribution list. This would be great in terms of maintenance like you said. We already are storing names and Email addresses.

By “programatically adding” email addresses, I’m assuming that it would require VBA programming? I don’t have slightest clue in regards with VBA, although, I’m planning to take a course in March.

My end-user wants to add it to a specific distribution list. I believe she already has a distribution list set up.

Oh, it would be nice if I could make sure that Access will NOT add duplicate addresses. This database is for a camp and people apply annually for it.