Missing Fields

M

MaryBethK

Im needing to add a field to my form but I cant find it in the field list.
Its already added into my table and is functional but When I go to add it to
my form I dont have it in my field list. Is there a way I can search for it
without having to start over on my form?
 
R

Rick B

Your form is most likely based on a query, not a table.

Add the field to the query as well. This query may be a saved, named query,
or it could be an SQL stored within your form.

Open your form in design-view.
Go to the FORM's property box
Click DATA, then RECORD SOURCE
Click the elipse to the right of the record source. This will open the
query builder.
Modify the query to include the new field(s).
 
M

MaryBethK

Ok, when I go to DATA the whole tab is blank, there are no lines, titles or
anything to type in or select. I know where the record source is but it isn't
showing on the sheet. HELP!!
 
Top