PDA

View Full Version : Enumerated Fields in a Form?



mud2
03-25-2009, 01:25 PM
Is there a way to enumerate the fields in a form, so that one can (Programatically) step through them, as in a do, or for loop?
Why?
I want to save the contents of one record and paste them into another.
Tanks!

Oh yes, a separate , disjoin question: Is there a "Help" web location as good as this one, for MICROSOFT'S FRONTPAGE?

orange
03-25-2009, 04:26 PM
For front page try
http://www.tek-tips.com/threadminder.cfm?pid=256


As for the form, if it's bound to a table,you can go to the table to add records.

Oorang
04-12-2009, 03:13 PM
One Way:

Sub example()
Dim rs As DAO.Recordset
Dim fld As DAO.Field
Set rs = Me.RecordsetClone
For Each fld In rs.Fields
Debug.Print Nz(fld.value, vbNullString)
Next
rs.Close
Set fld = Nothing
Set rs = Nothing
End Sub