Preview part of report on form

[ChrisDo11]

not sure if this is possible at all, but...

i have a form which is used to fill out a transmittal. On the transmittal form the user can enter names of people to be CC'd. The user types in the name, hits "add record" and the name is added to the cc list. A report is then used to print the transmittal.

I would like to have a list on my form which shows the names of all the people that have been added to the "cc" list and updates as more people are added. the only way i have been able to do this is to insert a subform based on the table holding the "cc" names and having it viewed in datasheet view on the form. no one likes the way this looks.... is there another way?

 

[Tiro Cupidus]

You can use a List Box.

 

[ChrisDo11]

how do i get the list box to update after each record is added?

 

[Mile-O]

Me.MyListBox.Requery

 

[ChrisDo11]

thanks! seems it was a pretty simple thing after all... .


i am still having one problem which is that when a new record is started the listbox doesn't update(clear iteself). is there a command that will clear the data in the list?

 

[Mile-O]

Me.MyListBox.RowSource = ""