Help with Making Form Alive and Kicking

[ACM]

Okay, so I've designed the form I need to. The problem is I don't know how I am meant to go about making it integrate wth the database.

It's a complaints form which allows the customer to fill out the complaint and I'd like it to store it in the database when the customer clicks 'Submit'.

If anyone could should some light as to what I need to do in order to do this then that would be great. There's a screenshot below to give you an idea.

http://img17.imageshack.us/img17/6844/complaintform.jpg

 

[Mr. B]

ACM,

I think you have the cart ahead of the horse here. You needed to design the structure of your database first. This is always the first step. You have to decide what data you need and just how that data may relate to other data that you will be needing.

Try thinking in terms of the data first, then you will need to design your form to accomodate the requirements of the data.

From the look of your form I can quickly see at least two tables. One for customers and one for the complaints. As you start to look into this you may even discover that you need even more tables to accomplish your goals.

Please post back here as you have questions.

Now, with all that said, if you are not mad at me and are still reading this, for the sake of answering you question specifically, you could just create a table with fields that represent each of the items of data that you are trying to capture using your form. Then make this table to be the record source for your form. You do this in the properties of your form.

Good luck with your project.



These comments are not meant to be mean spirited, but quite frankly you can't just start deisgning forms and have a successfully designed and functional database.

Do a search on normalization and database design.