We have a form that has unbound calculation fields that we want to link to a table. Both the form and the table have already been created. How should I start my Visual Basics entry? I keep trying the following and both keep giving me a syntax error when I try to open the table, or they give me an #error or ?Name in the field on the Form.
Code:
Dim Rs As Recordset
Set Rs = CurrentDb.OpenRecordset("Issues")
Rs.AddNew
...