Check out some similar questions!

g13544055 · Feb 16, 2010, 04:05 AM

Hi guys,
I want to create a database that has only one table.. with a nice form on the front of it. It's for a charity that is just starting up and I would like to be able to manage the members of this charity. The only functionality needed is that I can search for members based on their member ID, and I can edit the database. I would like to be able to do all of this via the form, so that the database is only used as a storage kind of thing.

Any advice would be great... the problem I am having is linking the database with the form, so that I can carryout these functionalities.

Cheers, G.

ScottGem · Feb 16, 2010, 04:09 AM

There are templates for Contact Management that can get you started. But if you want something very simple, create your table, then use the Form wizard to create your form. You can use the Filter by Form feature to find a specific member.

g13544055 · Feb 16, 2010, 04:52 AM

The templates are too basic. I've created the design of the form, with command buttons e.t.c... I want to be able to click on the command button and it opens a new page with all the details from the table laid out on the form, and I just enter the member ID and hit enter and it populates all the fields with the information on that member. Is this complicated?

ScottGem · Feb 16, 2010, 07:40 AM

Hmmm, The templates are too basic? You are talking about a 1 table/ 1 form app. I was worried you would have thought them too complex.

No what you want is not complicated. I told you how to do it. You don't need command buttons. You don't need to open another form.

Again, design your table (tables get designed first, not forms). You then use the Form wizard to create your form.

I recommend using Filter by Form to do your searches. This way you can search on name or member number or any criteria. Another option is to use the Combobox wizard to create a Search combo where you can select from a memberID to bring up that record.

If you really want to use the form you have designed, then you can link the form to the table by setting the Recordsource property of the Form to the table. You will then have to set the Controlsource property of each control to the field you want to connect to. I would really suggest using the Form Wizard and start from scratch.