VBA Help (1 Viewer)

I have an unbound text box called summary that pulls data from the below fields after the = sign from my form. The problem is I want it to pull from another table in my access database and the end of the code below like & Remedy_Templetes_List and the field name Summary. The table is called Remedy_Templetes_List and the field name is called Summary

Summary = [Department] & " " & "-" & " " & [Building] & " " & [Room] & " " & "-" & " " & [Class] & " " & "-" & " " & [Affected_#_of_Users] & ";" & " " &

Sounds like you are trying to get very similar data from two different tables.

This generally means there should only be one table.

You can simplify each instance of

& " " & "-" & " " &

to simply

& " - " &

If you want to look a value up in an unrelated table you would need to use a DLookup(), possibly based on a value in your current record.
The syntax and a guide to its use is available in the links in my signature.

It's not very clear from your question how the data relates to each other.