 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / February 2005Form: Auto fill by previous row?
Hiya, I am kind of a novice at this and I think there might be a very easy solution to this that I am missing... I have a form that we fill out for a patient's medication use. The underlying table has the pt id, and visit id and then the meds (type, dosage, route etc... for up to 8 meds.) So when the form pops up for a specific patient there are 8 "pages"/rows with the first being the first visit... 8 visits total. On their second visit their med use is almost always the same as the first visit. What is an easy way to autofill the second visit med use with the first visit info? Thanks, Gordo > On their second visit their med use is almost always the same as the > first visit. What is an easy way to autofill the second visit med use > with the first visit info? > > Thanks, > Gordo One way would be to get the ID of the first visit and then grab the child records from it and insert them with the updated visit info (second visit). So, create a query that grabs the meds info from the previous visit. Turn it into an append query, but with the current visit's ID. (You should be able to point the query at the form you have open.) Then run the query. Test it out in a dummy database, then when you're sure it works, do the usual - turn warnings off, run append query, turn warnings back on, requery subform recordsource etc. I had this idea, but I thought there might be a simpler solution. How would I "point the query at the form"?? SELECT .... FROM .... WHERE IdentifierField=[Forms]![MyFormName]![MyControlName] and make sure the form is open when you run it.... Excellent... thanks so much! You could do it by hand with "CTRL-'" (That's control and apostrophe) - which copies the data from the row above... Steve > I had this idea, but I thought there might be a simpler solution. > > How would I "point the query at the form"?? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.