By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,633 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

Autocompleting based on an ID

P: 4
Window's: Access 2000

I'm working on a project which involves entering data into a form from patient medical records. Each patient has their own unique medical record. From another earlier project, we have compiled a good amount of data on some of the patients (date of birth, initials, etc.). These important recurring variables are stored in a table in the same database as the new table as well as the working form.

I am looking for a way to make it so that once a medical record reviewer enters a patient's medical record number it might:

Let NewData(DateOfBirth)=OldDate(DateOfBirth)
Let NewData(PatientInitials)=OldData(PatientIntials)

I have a feeling this should be accomplished by some event in the AfterUpdate on the MedicalRecordNumber field, but my botched attempts, have ended... botched. There is also the problem that there might be a new Medical Record Number that might not exist from the old database table.

Any suggestions for auto completing, or am I thinking outside of Access?
Apr 10 '08 #1
Share this Question
Share on Google+
1 Reply

P: 8
Why not just append the old info to the new table and let not have two tables storing the same info?
Apr 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.