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
|
|||
|
|||
Form Field won't update two different tables
I have a from field that I added to a form. All other fields in this form
are linked to Table 1 (the form was created to fill Table 1) but this new field needs to update Table 2. I have the field linked correctly as I can see but it does not appear to be working any ideas as to why? |
#2
|
|||
|
|||
Form Field won't update two different tables
First, it is not a field, it is a control. Only tables and queries have
fields. Forms and Reports have controls and controls can be bound to fields in the form's recordset. This is the problem you are having. The control you are using cannot be bound to a field not in the form's recordset. It may be possible for you to use a query that includes the field from table2 provided there is a way to relate the two tables; however, in some cases a query is not editable. That depends on the relationship of the tables. Another solution would be to create a subform and use table2 as its record source to make the field available. -- Dave Hargis, Microsoft Access MVP "dbmondo" wrote: I have a from field that I added to a form. All other fields in this form are linked to Table 1 (the form was created to fill Table 1) but this new field needs to update Table 2. I have the field linked correctly as I can see but it does not appear to be working any ideas as to why? |
Thread Tools | |
Display Modes | |
|
|