How we can grab value from list box and fills automatically related text box in new f

[masoud_sedighy]

I have a list box and its row source is "tblitems" with bellow fields.

Now I like when right click on this list box and select one option for example "new task" it opens new task form like attached picture and automatically Grab the item number from a list box and fills related text box "item number" in "new task" form that is bounded to table "tbltask"

Now when I press "Apply" button it insert new record in "tbltask".

tblItems

item number (pk)

item name (text)

tbltask

task number (auto number,pk)

item number

[June7]

I have never seen a listbox with embedded icons. How is this constructed? That looks like a custom shortcut menu.

With bound form, record is committed to table when close form, move to another record, or run code to save.

Code in the listbox AfterUpdate or Click event can open form and pass the ItemNumber with OpenArgs argument.

DoCmd.OpenForm "NewTask", , , , , Me.ItemNumber

Code in the form Load or Open event can populate textbox, something like:

If IsNull(Me.ItemNum) Then Me.ItemNum = Me.OpenArgs