Add Record to the subform (1 Viewer)

[snirben]

Hi Everyone,
Need your help.
i have a form with tabs and in one of the tab (page 41 index 1) there is a subform.

the subform view is a spreadsheet, when i click on the "ID" in the Spreadsheet it opens up a another form as Popup with my list of Proudcts.

here comes my question:

i want to do event on double click to add the ID to the Subform and then exit the popup Products form, and when i click the next value it open up the popup again and i can insert the next ID to the list.

 

[Ranman256]

Don't do that.
There's no need since the subForm will enter the ID automatically.
Remove the dbl-click event,
In the subForm property, set the LINK CHILD ID and LINK PARENT ID to the ID field.
Then entering data in the sub form will fill in the ID,

 

[snirben]

Don't do that.
There's no need since the subForm will enter the ID automatically.
Remove the dbl-click event,
In the subForm property, set the LINK CHILD ID and LINK PARENT ID to the ID field.
Then entering data in the sub form will fill in the ID,

yes but the user dont know all of the products i have more then 1500 Items,
i just want to open a popup form with the list and when the user duble click the item the id will copy to the ID Field in the Subfrom
can it be possibale?

 

[Ranman256]

If you want to add many items, show a list box,
dbl-click the list box of products to add the item to the subForm table (append qry)

 

[snirben]

If you want to add many items, show a list box,
dbl-click the list box of products to add the item to the subForm table (append qry)

can you be more specifec on how i do that?