Solved Append Data

[gstylianou]

Good evening to all,

I need your help with the following problem.
In the attached database, there are the tables Customers and Messages. You can find also the form (SetMsg) which after adding data into [txtMessage] field i want append these data into Messages table, but only for those customers who has the field [Selected]=True.

The second issue is to append also the customer no for appended data and here is the basis problem. Can anyone help?

thanks in advanced

 

[bastanu]

Please have a look, not sure if that is what you had in mind.

Cheers,
Vlad

 

[Pat Hartman]

The problem was that the CustID was missing from the append query so the query was getting an error. While you are testing, always leave warnings on. You would have seen the error and been able to fix it.

I changed a couple of details such as table level defaults and required fields. I corrected a typo also. Looks like you are using English so I changed Appent to Append. I added some validation so the append query won't run unless there is a message to send. I added a requery so that you will see the message on the form if you are positioned on a record that is getting the message.

I don't really know what the objective of this app is but I'm guessing that you will want to add an update query that resets the send to false to remove all the checks.

 

[gstylianou]

I would like to thank you all for your help, finally the problem was really simple but happened....

thanks again all of you