I have a Master & Template in Access 2010. We have added 2 values to a table that is used by the Query and then the Template as a lookup field. Although the values are showing in the Master, they are not showing in the template. Could you please help me on how to refresh/update the choices. I can't find a good answer anywhere. Thanks!!
-
-
By Master and Template, do you mean a back end for the data and front end with linked tables? If so, then you just need to go to the External Data tab and click the Linked Table Manager (second option from the left) then check the table that you changed and click OK and it will update the linked table design. -
Sorry....Not great with the terminology and I am not the originator of this file. I have an accdt file that uploads to a separate accdb file when "send" is hit. In the db file, the source table (in which I need to add 2 values) feeds into the backend table. In the template, the control source is the backend table and the row source is the source table (again, where I need to add 2 values). My changes show up in the source table and nowhere else. I tried to illustrate below. Lastly, the "Linked Table Manager" is grayed out for all of my tables/queries. THANK YOU VERY MUCH FOR YOUR HELP!
Case Manager Template-- (with Specialist list box)
pulls from:
Tech Assist Query--
pulls from:
Tech Assist Table -- (renames field to Specialist & uses the following lookup:
Display control: List Box
Row Source Type: Table/Query
Row Source: Manager
Allow List Edits: Yes
pulls from:
Manager(A, B, C, D,) - - Source Table to add valueComment
-
I think that you will just have to recreate the template with the new design. I don't know of a way to edit a template once it has been saved as a .accdt file. Opening it just prompts you to save it as a new database. I'll admit that I'm not very experience with Access template though, so I might be wrong.Comment
Comment