How do I add a text box(bound to a field) to an existing form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a form from one of my tables using the wizard, then I added a new
field to the table. I would like to create a text box for this field on my
form..It doesn't show on the availbe field list since I added it after using
the wizard.
 
Oetzel,
If you have a table name indicated in the RecordSource for your form,
then the new field should be automatically included in fields available to
your form.
But... you probably have a query behind the form, that calls out all the
"old" fields individually in the design grid. Using the query design grid,
make sure that you have "dragged" that new field onto the grid.
Then that field will be available to place on the form.
hth
Al Camp
 
I created a form from one of my tables using the wizard, then I added a new
field to the table. I would like to create a text box for this field on my
form..It doesn't show on the availbe field list since I added it after using
the wizard.
Click to expand...

This is because Access (or, perhaps, you) has created a hidden Query
as the recordsource for the form; adding the field to the table
doesn't automatically add it to the query.

Open the form in design view, and view its Properties. The first one
on the data tab is the Recordsource property. Click the ... icon by
this; a query design window will open (perhaps after a prompt).

Add the new field to the query grid, close the query design window,
and accept Access' prompt to update the SQL. The new field should now
be available.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top