I added a new field to an exsiting table???

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

Guest

I also added it to a qurey, that I have a subForm made from. But in the
subForm this field does not show. What am I doing wrong?
Not sure where to post this.

Diane
 
Hi Diane

You will also need to open your subform in design view and add a textbox (or
some other appropriate control) bound to the new field in your query.
 
I also added it to a qurey, that I have a subForm made from. But in the
subForm this field does not show. What am I doing wrong?
Not sure where to post this.

Diane
Click to expand...

Open the Form (the one you're using as a subform) in design view; view
its Properties; select the Recordsource property (first on the design
tab); click the ... icon to open the query in the Query Designer.

Add the new field; close the designer, and accept Access' offer to
save the SQL.

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating tables when you input new data 0
Adding a new field to a form in Access 2002 3
Subform Field Visible Set to false but still visible 1
Access Daily Entry with multiple entries per field 0
If field =15 save in two tables 2
color of field in each record of datasheet depends on other field 1
how to create new record automatically 2
Use TextBox on the main form to limit SubForm 2

Back
Top