I have a button that runs a querie which returns a patient record based on the patient medical record number in table view.

How do I get the data inserted in the respective form text boxes after running the querie instead of in table view?

(I also need to be able to insert new data via my text boxes if a patient doesn't exist)

thank you for your help ~ Jennifer

Create a form based on your query. From the form where the user selects which patient to show put a command button to open the form that is based on your query. When they select the patient and then open your new for the query data will be there in form view rather than datasheet view. If your query is not based on a couple of tables you should be able to update missing data in your new form.