G
Gweny
Can anyone help me?
I have a form which is created from a combination of customer details
table and quote details table. When I enter the customer ID, the
customer address details automatically update on the form. However,
this information does not enter back in to the corresponding quote
details table.
Can anyone help me write VBA code to have the lookup details entered
into the table as soon as a change is made? Is there some sort of way I
can commit to the changes made in the form so that it writes to the
table after the change has been executed?
I have tried various different ways including queries, which I know
don't save data but seem to get
the same problem that the information does not show up on the quote
details table to allow me to do a merge in to word.
I am seriously tearing my hair out on this one!!!!
Cheers,
Gwen
I have a form which is created from a combination of customer details
table and quote details table. When I enter the customer ID, the
customer address details automatically update on the form. However,
this information does not enter back in to the corresponding quote
details table.
Can anyone help me write VBA code to have the lookup details entered
into the table as soon as a change is made? Is there some sort of way I
can commit to the changes made in the form so that it writes to the
table after the change has been executed?
I have tried various different ways including queries, which I know
don't save data but seem to get
the same problem that the information does not show up on the quote
details table to allow me to do a merge in to word.
I am seriously tearing my hair out on this one!!!!
Cheers,
Gwen