If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding new fields to an existing form/subform
If a table is updated with a new field, is there any way
to add that field to an existing form/report. I have tried using an expression in an unbound field but something is going wrong! Many thanks in advance L |
#2
|
|||
|
|||
Adding new fields to an existing form/subform
Hi Linda
if the form / report takes its record source directly from the table then you can display the 'field list' (it's a little box on the toolbar when in design view of either forms or reports .. also found under view / field list ) and then you can drag the new field on the the form / report if the form / report is based on a query, ensure the query has the field in it and then you can use the 'field list' icon to get it onto the form/report. Hope this helps Cheers JulieD "Linda" wrote in message ... If a table is updated with a new field, is there any way to add that field to an existing form/report. I have tried using an expression in an unbound field but something is going wrong! Many thanks in advance L |
#3
|
|||
|
|||
Adding new fields to an existing form/subform
If the RecordSource of your Form / Report is the Table to which you added
the Field, the new Field should be available and you can set the new Filed as the ControlSource of the Control (Textbox?). If the RecordSource is a Query or SQL String, you need to modify this to include the new Field in the Query / SQL String before you can use the new Field as the ControlSource. -- HTH Van T. Dinh MVP (Access) "Linda" wrote in message ... If a table is updated with a new field, is there any way to add that field to an existing form/report. I have tried using an expression in an unbound field but something is going wrong! Many thanks in advance L |
#4
|
|||
|
|||
Adding new fields to an existing form/subform
What if the field is in another table? How can you add a field to the form
that has its recordsource from tblOne but the field is in tbl 2? What about putting fields from several tables on one form without creating a subform? Thanks, Another Linda "Van T. Dinh" wrote in message ... If the RecordSource of your Form / Report is the Table to which you added the Field, the new Field should be available and you can set the new Filed as the ControlSource of the Control (Textbox?). If the RecordSource is a Query or SQL String, you need to modify this to include the new Field in the Query / SQL String before you can use the new Field as the ControlSource. -- HTH Van T. Dinh MVP (Access) "Linda" wrote in message ... If a table is updated with a new field, is there any way to add that field to an existing form/report. I have tried using an expression in an unbound field but something is going wrong! Many thanks in advance L |
#5
|
|||
|
|||
Adding new fields to an existing form/subform
If you don't want to update the Field in Table2, you can simply use a
Calculated Control with DLookUp() function. If you do, you will need to create a Query linking & selecting data from 2 Tables and use the Query as the RecordSource for the Form. The alternative is to base the Form on Table1 and use VBA code to handle the editing of data from Table2. -- HTH Van T. Dinh MVP (Access) "LMB" wrote in message ... What if the field is in another table? How can you add a field to the form that has its recordsource from tblOne but the field is in tbl 2? What about putting fields from several tables on one form without creating a subform? Thanks, Another Linda |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
URGENT: Adding Text to existing text | Sat | Worksheet Functions | 2 | July 19th, 2004 03:48 AM |
Adding 2 fields | Bruce | Database Design | 5 | June 22nd, 2004 01:49 AM |
Adding fields in a table | tpitman | General Discussion | 0 | June 20th, 2004 05:08 PM |
Adding New Fields to an existing form | Sarah Hill | Database Design | 3 | May 28th, 2004 04:54 PM |
problem adding button to an EXISTING dropdown menu on a Worksheet Menu Bar | Karen P | Worksheet Functions | 2 | October 29th, 2003 12:42 AM |