Fields in my table not coming into my form

D

Don Juan

Can you help with this?
I have created my table and am using the wizard to create the form.
The normal is that all the fields in my table are displayed so that I can
select which ones I need. However all I can see is the first field in my
table.
I have used this method on other tables on other machines, but this is new
problem to me.
Thanks
 
A

Al Campagna

Don,
It's very rare that a form is actually based on a "raw" table. You may want to sort
the recordset differently than the table default sort, or... filter out old records from 3
years ago, etc... etc... which a straight table RecordSource doesn't easily allow for.
Use a query instead, based on that same table, and you'll be able to get the same
results as a table, but with more control... if needed.
Select RecordSource for the form, click the (...) button on the right, and use the
query grid to lay out all your fields/sorting/criteria....
Then all those fields should show in the Field List when you return to form design.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Top