Add record to form from subform button

[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?Progetti.zip

[ranman256]

run an Append query to add the record to the table in the dbl-click event.

[cesarone82]

Thanks,

Don't really know how to do but I'll try, anyway I suppose it is possible to add just some record of a table to some records of a different table (I mean the table are not the same).

Thanks

[cesarone82]

I tried a bit,

But I don't understand how to specify that the value to append to the append query should be a specific value in the recordset clicked , and the other value should be the value identifying the project number of the form project which is open.

It is a bit tricky, if you open the attached file you should understand what i mean

[Welshgasman]

You would build an Insert query sql in vba, concatenating the values required.
You could pass in the required project number in as an OpenArgs or set a tempvar to that value.
Then you have both the values required for the record.

[mike60smart]

Hi
You need to get your relationships between tables correct before doing anything else.

tblClients - You have the PK set as just a Number DataType - It should be an Autonumber

tblProjects - you are linking the field PjNum which is a Number Datatype to the PjNum in all related tables
(tblPjEntries/tblProjclients/tblProjProf & tblProjimprese)

You should be linking the PK PjID from tblProjects to all related tables on a field named PjID and NOT PjNum)