Help updating tables with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that pulls data from a table called "Names". This table has a
relationship to another table called "Dates". I am trying to put a command
button on this form, that when clicked, would add data to 2 fields in the
"Dates" table. All I seem to be able to do is add data to the "Names" table.
The "Dates" table is a Subform/Subreport on the main form. Is there a way
to do this?

Any help would be appreciated.

Vince
 
Vince,
if nobody is helping you with this, I will be happy to help you. If so can
you zip the tables and forms up and send them to me with a little more detail
on what it is that you are wanting. ie... what 2 fields need updating and
what exactly are they supposed to be updated with. If you click on my name in
blue at the top of this reply you will see my address embedded between to
bookends called spamfreeplease@ my email is in the middle.
 
Vince,

The essence of this would be to use an Update Query (or possibly an
Append Query, it is not clear from your post what you want to do). If
you can make an Update Query or Append Query to make the required
changes to the data in the Dates table, then you can use a VBA procedure
or a macro on the Click event of the command button which will run the
query.

If you need more specific help, pleased post back with more details,
with examples.
 
Back
Top