linking names and addresses

UCLA Lorna

Registered User.
Local time
Today, 05:05
Joined
Mar 8, 2005
Messages
32
This might be a basic Access application, but I'm having trouble. I want to create a name and address table that will include all patients in my clinic, identified by unique patient ID numbers. I then want to create 3 other tables for the information collected at the 3 appointments I will have with each of these patients. I've created 4 forms, 1 for each table; each a control for patient ID, name and address. How do I create a link so that I can enter the patient ID number in the appointment form and the name and address will appear automatically in my form? Is this possible? Thanks for your help on this.
-Lorna
 
Lorna,
Yes it is, would you prefer for me to post an example database or would you prefer sending yours for me to work on?
Chris
 
if it's easy enough to post an example that would be great. thanks so much!
 
Made this in a hurry but it should show you what your looking for,
Where it Says EnterID, Enter any of the following: 001,002,003,004 and then press your Enter key on the keyboard.
Attached Sample.
Get back to me if you get stuck.
Chris
 

Attachments

OK - So I can see what you're doing with the Query, but I am getting an error in the ID and address controls on the follow-up form. I created a fake database to test the code, and I'm still having trouble. Are there Access settings that might prevent me from executing your query from the form?

Here's my test database - it looks exactly like yours that why I'm guessing it's some Access setting...
 

Attachments

Last edited:
You had a few Syntax errors and required some vba in the change event of the id field.
Attached is the corrected version.
Chris
 

Attachments

Users who are viewing this thread

Back
Top Bottom