Rob,

Ok, back on the trail from the original threads in this topic.

You showed me the SyncControlsToRS example. Well I have had a go myself, tried to build it normally into the existing code, I ended up with a funny error message that just dont understand, but then thought well I'll try it the way you had said and I get the same error message. Dont understand the error message firstly.

"Item cant be found in the collection corresponding to the requested name or ordinal"

What does that mean?

Public Sub QuestionsRSControls()
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
txt.QuestionNo.Value = rs.Fields("Question")
txt.QuestionNoText.Value = rs.Fields("QuestionText")
Set rs = Nothing
End Sub

In this code above I think I was trying to assign the field Questions to the Unbound TextBox (txtQuestionNo) on my form. Have I gone a miss somewhere?

Jez

Jez,

Hello again! =)

Ok the error message means (in English lol)
"I cant find what your looking for with that name or index number"

Now, the "Collections" you are trying to access is the "Fields" collection, this is the columns
within the Recordset.

Check that the field names you have given exist within the Recordset. You need to use the field
names in the SELECT statement of your SQL.

e.g.
"SELECT MyTable.MyField FROM MyTable" can be used to produce a Recordset. To access the Field Value, you need:
- See how the field names match?

I hope this helps.

Kind Regards,
Rob

<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>