Alright.. Here I am with another puzzle (at least for me)



I have a form with two tables..

Table 1 has payment data on it from a customer (example.. Name, address, CC# and Ex Date)

Table 2 hold other information and has the form related to it.. So I have a combo box that pulls the data from Table 1 and is added two Table 2.

But once the payment as been successfully taken, I want to some how update Table 1 with some type of "update" field (Example.. Button, Update Button, Check Box, etc..)

Is this possible??

Thanks in advance

Chad