Add record on doubleclick on another form

[cesarone82]

Hi

I have a subform (a correspondence table) with a button which opens a form containing a client list. I'd like a client to be added to the correspondence table by double clicking on the form.
The form is tbl_projclienti, the button is the one on the right which opens a client list, I'd like the record to be added by double clicking on the specific client.
Any help?

The form where i have to add a record is just a correspondence table, where I ahve a list of codclients assigned for every Progetti.zipproject.

[Welshgasman]

Don't post the same question twice, without advising people?

Cross posted https://www.accessforums.net/showthread.php?t=89011

[cesarone82]

Yes sorry, I was not sure which one.

Don't post the same question twice, without advising people?

Cross posted https://www.accessforums.net/showthread.php?t=89011

[Welshgasman]

The form where i have to add a record is just a correspondence table, where I ahve a list of codclients assigned for every Progetti.zipproject.

That is not a subform but a main form?

Where do you intend to get the project number from?

[cesarone82]

If you open the mainform projects or progetti i don t remember, there should be a sub form named projclienti (a correspondence table which has a a list of codclients assigned to the specific opened project in the main form), where i placed a button which basically opens a client list.

Double clicking a client in the client list I should add a record to the projclient table with pjnum equal to the pjnum of the active project in the main form and codclient of the client where i double clicked in the client list. Basically assigning a client to the project number.

That is not a subform but a main form?

Where do you intend to get the project number from?

[Welshgasman]

Seems my last reply went walkabout?

Either pass the project number in to the second form as openings, or set a temp variable with that valu.
Then you will have all you need to build the Insert sql statement, concatenating the values.

[cesarone82]

Ok thanks, managed to make it work, now upon opening the lists form with the button located in the main form subforms; if i double click a record, that is correctly added to the project, with the doubleclick event procedure.
I attach the file in case someone has comments or wants to see.Progetti.zip