copy/pass value from Form(A) listbox(a) to another Form(B) listbox(b)

[PoorBoy]

i have 2 forms , form(A) and form(B)
each form have a listbox, listbox(a) and listbox(b)
and 1 button

how do i copy/pass value from Form(A) listbox(a) to another Form(B) listbox(b) by just clicking a Add button

thanks please help

[rpeare]

are you copying the value, or are you copying the record.

If both list boxes have the same data source and you're just trying to pass your 'current' record you should be able to do something like

[forms]![secondaryformname]![secondaryformlistboxname] = [forms]![primaryformname]![primaryformlistboxname].

If you're actually trying to add a record to a table then refresh the listbox on the secondary form in your on click event you'd have to:

1. Append a record to the table that the secondary form list box is using as a record source
2. Possibly issue a me.refresh command
3. Issue a me.requery command of the secondary form list box.