VBA Newbie Syntax Question

[CJ]

Hi!

I am trying to find the proper way to set a variable.
What I am trying to do is set a variable so its value is
the value of a specific field from a table.

Set dbs = CurrentDb()
Set rSchedule = dbs.OpenRecordset("Schedule",
dbOpenDynaset)
Set rScheduleDtl = dbs.OpenRecordset(sSQL)
Set rCabins = dbs.OpenRecordset("Cabins")
rCabins.Index = "Cabin"

Set CabinFieldName = ???????

What is the proper syntax to set the variable so that it
points to the Cabin field in the Cabins table?

Thank you in advance for your help!