Enter new record in table with VBA

  • Thread starter Thread starter Rich F
  • Start date Start date
R

Rich F

I know this is probably simple, but how do you enter data into specific
fields in a table using VBA? I can do it w/ a macro, but I'm not able to do
it yet w VBA.
 
Rich,

Where does the data come from? What do you mean by "I can do it w/ a
macro"? Is an Append Query relevant to what you are doing? Maybe you
could give an example?
 
I want to use a command button so that when the command button is selected it
will use VBA to generate a new record (with several fields) in a table.

I used a macro to OpenForm, GoToRecord, and Set Value to input data to the
table that way. It works, but I was thinking VBA would be a better way to do
it.

I'm still basically a novice with VBA...
 
Rich,

I can see what you were thinking with what you did with the macro, but
basically this is not a good approach anyway. This is not the intended
purpose of the SetValue macro action. This is a job for an Append
Query. The details of which would depend on your answers to my earlier
questions.
 
Back
Top