Creating Form from Table?

[New2Tek]

When creating forms, do you have to create them from using the tables or can you use create forms from scrath? I was told that it's wrong, but not sure. I tried to create a "tab form", but don't know how to do it using the table to transfer the field names over. Please help.

 

[PHV]

Create a query with all the fields from the table(s) you want on your form and then follow the form wizard to create a form bound to this query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Zion7]

As PHV said, that would be the easiest but, just for the record,
you could create a form from scratch, change the
"recordsource" property to any table or query you like,
from there, the "Fields" icon from your menu bar,
will offer all the available fields (dictated by your recordsource) available for drag & drop...

 

[missinglinq]

First thing to remember is that the Tabbed Pages are all part of a single form; think of it as a really long form turned on its side. Because it is all one form, all referrencing to any contol on it is done in the same manner as if they were all on one single screen.

Create a form in Design View. Goto the toolbox and click on the Tabbed Control icon; it actually looks like several manila file folders. Place it on your form and adjust the size to your liking. If you need more than the two tabbed pages it initially gives you, click on the tabbed control to select it. Goto Insert and click on Tabbed Control Page and another tabbed page will be added. Do this as many times as neccessary.

This is the really important part: when you go to add a control to a tabbed page, you must first click to select one of the pages, then add the control. Otherwise, the control will be added to the form itself, and will show thru on all tabbed pages!

Once you have the form's Control Source (your table or a query) set up, you simple add controls as you normally would, heeding the above paragraph.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!