combing two fields to create a third

[Guest]

I have a table with locations and a seperate table with scores. I need to
combine the location # with the test # to create a unique id # for each test.
I have the calculation I need, but cannot figure out how to have the
third/new field populate with the calculated information.

=[Location ID] & " - " & [Test #]

I need the solution for the above to populate a field in my form [instructor
score], field name [test id]

Help please.

 

[Guest]

First, please do NOT include either spaces or special characters in your
column names. It leads to extra work and can cause problems.
You need a query to populate the form, in your SELECT clause have
tblLocation.LocationID & '-' & tblScore.Score.TestNo As CombinedID
CombinedID becomes the record source variable to bind your control to.

-David