I am using ACCESS 97, and I have a camp registration database with the participants name, address, email address, amount of their registration deposit already entered. We process Visa payments through an online web page that has a HTML form that is filled in with the particulars for processing the credit card for approval. The problem is that currently I am having to retype all the personal information of the personal in this HTML form, including the credit card number and name on the credit card. On the HTML form, fill in name, address, city, state, zip, email, phone number, credit card type, name on credit card, and card number. Each of these fields has a particular name so that data is entered in the fields and then when the Submit button is clicked, the values pass to an Active Server Page through the Internet with these variables.

What I am trying to figure out is a way to query this information from my data (I know how to do that), but then to have it linked to an HTML form (web page) that "fills" in the information to these form fields, so that we can submit the form for processing to an Active Server Page. I don't want to have to retype the information already in my database onto this HTML form. I only need to submit one record at a time.

Thanks for your time in considering this.

Mike