Passing Strings to a Recordset Located in a Class

[Matthew Cuda]

Could someone give me some code for passing strings to a recordset that was connected in a class.

Example:
strLastName to this recorset in a class - rsHelpDesk!LastName


I have been able to pass info Read only(property get), but can not write to the DB.

Thank You

[robinm]

there are two ways to do this.

1)1 Define a number of Properties for the recordset class that are public Let (get if you also want to read them)
2 Assign the Surname ForeName etc to the properties of the
recordset class.
3 To assign them to the recordset use the pre set property ;

rsHelpDesk!LastName = Surname
rsHelpDesk!LastForeName = ForeName ..... etc etc


2) 1 Use no properties (Stateless class)

2 Define a public Method in the recordset class that accepts all
the values for the recordset .

ie . Public Function AddRecord(byval ForeName as string, byVal
_SurName as string.... etc etc etc)

rsHelpDesk!LastName = Surname
rsHelpDesk!LastForeName = ForeName ....etc etc

Any questions mail me.