adding a bound field

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

Guest

I have a form that is made up from two tables. I have created the form using the wizards

i have now added another field to one of the tables and would like to add it into the form

I have tried to look in the field list in the design view but it is not appearing. Is there any way that i can add in the field without having to completely re-create the whole form

Thanks
 
After adding the field to your table and saving, you reopened your form in
design view, opened the Field list (View menu), and the field is not there
to add to your form?

Is the form based on a query? Check the RecordSource property of the
Properties box (Data tab, making sure you are looking at the properties of
the Form, not those of a text box). If so, open the query in design view,
add the new field, and save the query. Then close and reopen the form.

If that does not solve the problem, you may have an issue caused by Name
AutoCorrect. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect.
The compact the database:
Tools | Database Utilities | Compact
and try again.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

matthew said:
I have a form that is made up from two tables. I have created the form using the wizards.

i have now added another field to one of the tables and would like to add it into the form.

I have tried to look in the field list in the design view but it is not
Click to expand...
appearing. Is there any way that i can add in the field without having to
completely re-create the whole form.
 
Hi

The form isn't based on a query, it is made up from two tables. tblcustomercalllog & tblstoredetails.

I have tried to add an area field into both tables and then re-open the form and then the field list but for some reason it doesnt appear either way.

your help is appreciated - thank you
 
Matthew, I don't understand how the form is based on two tables, not a
query.

If you open the form in design view, what is in the RecordSource property?
(First entry on the Data tab of the Properties box, when looking at the
properties of the Form (not a control)).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

matthew said:
The form isn't based on a query, it is made up from two tables.
Click to expand...
tblcustomercalllog & tblstoredetails.
I have tried to add an area field into both tables and then re-open the
Click to expand...
form and then the field list but for some reason it doesnt appear either
way.
 
okay, im talking complete nuts..

the form is created from one table.. however it is used as a subform in main form

I want to add a field to the subform. I have added the field in design view in the table but when i go into the form nothing appears in the field list

Think thats right now! - Thanks for your hel

Matthew
 
1. Locate the subform in the Database window, on the Forms tab.

2. Open it in design view.

3. Open the Properties box (View menu).

4. What is specified for the RecordSource property (Data tab of Properties
box)?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

matthew said:
okay, im talking complete nuts...

the form is created from one table.. however it is used as a subform in main form.

I want to add a field to the subform. I have added the field in design
Click to expand...
view in the table but when i go into the form nothing appears in the field
list.
 
SELECT DISTINCTROW [tblcustomercalllog].[ContactID], [tblcustomercalllog].[Date], [tblcustomercalllog].[Queries open/closed], [tblcustomercalllog].[coast/oasis], [tblcustomercalllog].[Person Dealing], [tblcustomercalllog].[FirstName], [tblcustomercalllog].[LastName], [tblcustomercalllog].[Address], [tblcustomercalllog].[City], [tblcustomercalllog].[PostalCode], [tblcustomercalllog].[WorkPhone], [tblcustomercalllog].[Product Code], [tblcustomercalllog].[Problem], [tblcustomercalllog].[Store No], [tblcustomercalllog].[ContactTypeID], [tblcustomercalllog].[Action Required], [tblcustomercalllog].[GV's], [tblcustomercalllog].[Refund], [tblcustomercalllog].[Send for QC], [tblcustomercalllog].[Store Contact Name], [tblcustomercalllog].[Store Address], [tblcustomercalllog].[Store Tel No], [Store Details].[Coast/Oasis], [Store Details].[StoreNo], [Store Details].[StoreNme], [Store Details].[StoreAdd], [Store Details].[StoreTel] FROM ([Store Details] INNER JOIN [tblcustomercalllog] ON [Store Details].[StoreNo] =[tblcustomercalllog].[Store No]);
 
enterprise support - i heard you the first time, please please dont get keep replying to my posts!
 
Great.

Now add the field to this RecordSource statement. For example, if the new
field was added to tblCustomerCallLog and was called MyNewField:

SELECT DISTINCTROW [tblcustomercalllog].[ContactID],
[tblcustomercalllog].[Date],
[tblcustomercalllog].[Queries open/closed],
[tblcustomercalllog].[coast/oasis],
[tblcustomercalllog].[Person Dealing],
[tblcustomercalllog].[FirstName],
[tblcustomercalllog].[LastName],
[tblcustomercalllog].[Address],
[tblcustomercalllog].[City],
[tblcustomercalllog].[PostalCode],
[tblcustomercalllog].[WorkPhone],
[tblcustomercalllog].[Product Code],
[tblcustomercalllog].[Problem],
[tblcustomercalllog].[Store No],
[tblcustomercalllog].[ContactTypeID],
[tblcustomercalllog].[Action Required],
[tblcustomercalllog].[GV's],
[tblcustomercalllog].[Refund],
[tblcustomercalllog].[Send for QC],
[tblcustomercalllog].[Store Contact Name],
[tblcustomercalllog].[Store Address],
[tblcustomercalllog].[Store Tel No],
[tblcustomercalllog].[MyNewField],
[Store Details].[Coast/Oasis],
[Store Details].[StoreNo],
[Store Details].[StoreNme],
[Store Details].[StoreAdd],
[Store Details].[StoreTel]
FROM ([Store Details] INNER JOIN [tblcustomercalllog]
ON [Store Details].[StoreNo] =[tblcustomercalllog].[Store No]);

Beside the RecordSource property, there is a Build button which will open
this in query design view if you prefer to add the field that way.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

matthew said:
SELECT DISTINCTROW [tblcustomercalllog].[ContactID],
Click to expand...
[tblcustomercalllog].[Date], [tblcustomercalllog].[Queries open/closed],
[tblcustomercalllog].[coast/oasis], [tblcustomercalllog].[Person Dealing],
[tblcustomercalllog].[FirstName], [tblcustomercalllog].[LastName],
[tblcustomercalllog].[Address], [tblcustomercalllog].[City],
[tblcustomercalllog].[PostalCode], [tblcustomercalllog].[WorkPhone],
[tblcustomercalllog].[Product Code], [tblcustomercalllog].[Problem],
[tblcustomercalllog].[Store No], [tblcustomercalllog].[ContactTypeID],
[tblcustomercalllog].[Action Required], [tblcustomercalllog].[GV's],
[tblcustomercalllog].[Refund], [tblcustomercalllog].[Send for QC],
[tblcustomercalllog].[Store Contact Name], [tblcustomercalllog].[Store
Address], [tblcustomercalllog].[Store Tel No], [Store
Details].[Coast/Oasis], [Store Details].[StoreNo], [Store
Details].[StoreNme], [Store Details].[StoreAdd], [Store Details].[StoreTel]
FROM ([Store Details] INNER JOIN [tblcustomercalllog] ON [Store
Details].[StoreNo] =[tblcustomercalllog].[Store No]);
 
Back
Top