Updating a field in a new record added via bound form

G

Guest

I have a continuous form that's bound to a query. I'm adding new records.
AFTER each new record is added, I need to automatically go in and change a
field (column) in the new record. What do I need to do? Access 2002.

Note that NO NAVIGATION BUTTONS are on this form. It's for adding new
records only. Part of the form is pulled from one table, and the other table
is where the new data goes. (It's questions & answers. I pull the questions
up, the user enters answers, which get posted to an Answers table by
ApplicationID.) The problem is that since no records are added to the answers
table, I only know the AppID from the main form when the user looks it up. I
pass this value to a global var, and need to place it into the new answer
record as soon as it's posted.

Thanks!
 

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

Need combo box to refresh when moving to new record 2017 1
Access Automatically Send a notification email once a record is added 0
UNBOUND fields in a bound CONTINOUS form? 4
Cancel button on bound form 3
Bound Form to Table - Cancel Operation 4
Creating Checkbox Fields For Every Record 0
Lookup current record with ComboBox, any changes create new record 3
SQL Question and Form Field Displays 2

Top