How do I link/attach a form to a table?

[Wontonman]

I am new at this and have been struggling for days trying to solve this problem.

I created a database, using the wizard, to keep records of my orchids.

This resulted in a table. I keyed in the information on each plant.

Then I created a form, using the form wizard. Everything worked great. I could switch between the form and the table views.

The other day, the form no longer contained the information from each of my records. When I tried to switch to datasheet view (from form view), there was no longer a datasheet listed.

When I go directly to the datasheet (when starting Access), I can see all of the records (186 of them), but if I try to switch to form view - no form is listed.

Please help.

 

[gromit]

Hi - welcome!

Sounds like a frustrating problem. Try the following.

1. Open the form in design view. At the upper left, there should be a small box with a black square in it. Double click the black square.
2. This should open another window with the form properties. You should see the following tabs: Format / Data / Event / Other / All
3. Click on the Data tab
4. Where it says Record Source, see if the name of your table is listed If not, type it in exactly as you have table named. Then close and save the form, see if this takes care of the problem.

If the Record Source is already set to your table, then you may have a problem with the format of the form.

1. In the properties window, click on the Format tab.
2. There is a field for Allow Form view, make sure it says yes.

If you still have problems, then see if you can zip your database to a reasonable size and post to the forum.

hth,

- g

 

[Wontonman]

Thank you so much for your quick reply.

I tried what you suggested but neither worked.

Out of frustration, I started clicking on things and my accident, fixed the problem.

In Design view of the form, I clicked on Records - Remove Filter/Sort. Voila! All of my records appeared in the form! How that ever happened I have no idea. I guess after days of struggling with it, I needed your inspiration to solve it! lol

Thanks again. I will likely be back with more questions as prior to this I was getting 'validation rule problem' messages. I have read everything on validation rules, etc. but it may as well be Greek (and I don't read Greek). lol

 

[gromit]

Good Job!

Great, glad that you got it figured out!

You must have had a filter on that was eliminating all the records. Thanks for letting me know, I had not thought about that possibility.

Feel free to post other questions about validation rules, although please start a new thread so that others can "tune in"

- gromit