Pulling part of a table's info but needing all of the table's fields

[wgechter]

I have a table with patient ID, last, first, dob, diagnosis, place of service in it. What I need to be able to do is when the form opens it asks for an ID. I can create that parameter. IF that ID is in the database it pulls up last, first, and dob but I do not want it to pull up any old info from diagnosis or place of service. BUT, they need to be in the form for the user to fill out. What other information do you need? Do I need to create a seperate table with diagnosis and place of service in it? Thanks, Wendi

 

[lupins46]

If you are not doing data entry in this form then I suggest you create one version of the form for Viewing and a different one for data entry. You can then delete the unnecessary controls from the one you are using for viewing.