Creating an Update to New Record Command Button on Form Based on Multitable Query 
Author Message
 Creating an Update to New Record Command Button on Form Based on Multitable Query


I have a form that uses a multitable query as its recordset.  The underlying
tables are patient identifying info (tbl1) that doesn't change by admission
and the other is a table of stuff that does change by admission (tbl2).
tbl1 is the one side of a one:many relationship.  The underlying query then
has information from both tables such that if you try to write a simple
copy/pasteappend VBA routine acting on the underlying query, an error
returns stating that a duplicate record has been created (it tries to
duplicate the information in tbl1 that can only have one unique record per
patient).  So here's the question, what would the code look like to close
the form open a new query with only the fields in tbl2 for that record,
copy/paste to a new record with an updated date/time stamp, and then reopen
the form pointed to the new record with the multitable query?  I'm new to
vba and just can't seem to get it right.  Should I be doing this with SQL?
Please shed some light...thanks gg

Sun, 09 Sep 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. VBA codes for anking records in a query which is based on another quer

2. Command to Make a New Element based on a Form

3. add text in field in new appointment form with command button

4. Create a button to start a new message w/custom form

5. Problems creating a new Record in a Form

6. Updating a Recordet based on a command Object

7. NEWBIE: Creating a multitable Database using MS ACCESS

8. command button based on using SQL in On Cick's VBA

9. Enabling command bar buttons based on doc open or not

10. problem use old record to create new record

11. Elementary problem with a multitable form

12. Create new fields in a table based off of fields in another table


Powered by phpBB® Forum Software