Edit Subform Field List

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

Guest

Hello, I use Access 2003 Form Wizard to create a Subform. I need to change
some fields that I selected from various table. How do I go about adding new
field to the toolbar field list? The subform fields control source weren’t
base on any query.--
Tim
 
You will have a Record Source for your subform. You can open this in design
view to add or remove fields.
 
Duane, thank you for responding, I followed the instruction to open the form
in design view, however I don't know the procedure to remove the fields.
Clicking on Record Source build control gave an Access warning stating that
“you invoked the Query Builder on a table".--
Tim
 
A warning is just a warning is just a warning. No big deal. Forms can be
based on tables, queries, or SQL statements.
I am wondering what you mean by "procedure to remove the fields".
 
Duane, thank you, now it is working.
In design view click on the record source built control (…), this action
give “you invoked the Query Builder on a tableâ€, “do you want to create a
query base on the table†message. Select yes and you are directed to the SQL
Statement: Query Builder form. Click on the all-field reference tag (*) and
then the show table button. Choose the table’s and click to add the new
fields to the query pane. If the save button is click you will create a new
query, instead close the window, this will modified the original SQL
statement, and select yes from the warning message form and you are directed
to the original design view form. Select and delete any field from the form.
Select view from the Toolbar and drag the new field to the form.
 
Back
Top