Opening from a Master/Detail form to other

[dcb]

so any suggestions on how to open the patient details main form from the patient list main ensuring you goto specified patient

I see you are using Macros for this - Anyone else??? I am not the expert in the new 2007 macros

 

[ritchie_h]

if you know how via vb lay it on me

 

[ritchie_h]

Any body think they can help me with this problem, or offer a differend direction would be greatful....

 

[dcb]

OK
Added a button on Pateint List Main Subform - Have a look
There are many ways to do this BTW

Also look at the open event of Patient Details Main

Cheers

 

[ritchie_h]

Thats cool good work, I might end up using this method thanks for the hard work.

You said their are other methods, you mind elaborating a bit i will do the research and see if it is more profitable

 

[dcb]

For me the patient is the top of the DB structure not the Company
If you created a Single Form for the patient and had tabbed linked forms for all your other required inputs you could have a very easy UI - both to build and use
Drop the whole COMID that you have following you all over the place - as I said you have needless data in the table

 

[ritchie_h]

Even though harsh....with a after thought a very sensible idea...Thats eaxtly what i would doo...thanks a million and great effort on your part....