Hi,
Here's our situation...
We have a continuous form that pulls from a table to get the information (like a template). The field in the form that we are working on is dollars. The field is zero on each line on the form and on the table. We want to be able to overtype the zero and put in a new dollar value. We want to take the new dollar value to a second table through an append query in an event procedure. This works. However, the values will not carry over to the table unless the first line value on the form is changed. If you change the first line and any proceding lines, it works. If you bypass the first line and change the value on any proceding line it doesn't. The second table's field is zero and not the value that was put on the form.
Is there anyway we can bypass that first line on the form and still be able to carry the new value to the table on any proceding lines?
Thank you very much for your help!!
Here's our situation...
We have a continuous form that pulls from a table to get the information (like a template). The field in the form that we are working on is dollars. The field is zero on each line on the form and on the table. We want to be able to overtype the zero and put in a new dollar value. We want to take the new dollar value to a second table through an append query in an event procedure. This works. However, the values will not carry over to the table unless the first line value on the form is changed. If you change the first line and any proceding lines, it works. If you bypass the first line and change the value on any proceding line it doesn't. The second table's field is zero and not the value that was put on the form.
Is there anyway we can bypass that first line on the form and still be able to carry the new value to the table on any proceding lines?
Thank you very much for your help!!
