pass value in table from form to another form

[PoorBoy]

after filtering in the filter form, how do i pass the list4 value in the filter form to event form's scheduled list when i press add




Attachment 11590

[June7]

The Filter form does not filter anything. The form is not bound. What is purpose of this form?


If VolunteerScheduled field in tblEvent is supposed to be foreign key for the volunteer then this field needs to be a number not text type to allow saving the tblVolunteer primary key value unless you intend to save names concatenated as a single long string. That would not be a normalized data structure.

Why does listbox RowSource not include tblVolunteer ID field and set that as BoundColumn? Why is [Speak Other Language?] in there twice? Why is Activity the bound column? Need to set ColumnWidths property.

Advise no spaces, special characters/punctuation (underscore is exception) in names.