Adding new Rec

S

Steve.

I have a form that displays filtered data. One of the fields is a record Id
I want to use a "Add Rec" button and when it is used a new record to be
inserted into the database with the same record id that the user is currently
viewing. Any suggestions? I've tried using an append query and it inserts
correctly, but you have to back out of the form and open back up to get the
second rec with the record id populated. I also tried using Me.Refresh after
the
append query.
 

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

Top