How can I add records to a table using macros?

K

KenB

The record has only two fields which are bound to Text boxes on my form. Ive
tried:
GoToRecord New
SetValue FieldA
SetValue FieldB

which works for a single record. If I try to enter several records, only
the last one appears in the table - apparently written when the form was
closed.
How do I cause a 'write record' using macro statements?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I clear a form? 0
Number of Records 2
Exporting to Excel from Access 3
Writing a recordset to a table 1
Append query works in DB view not in macro 2
Setvalue Macro to a Subform 2
How To Move To Last Record in Form 2
How can I increment values of records on a form? 1

Top