Hi All.

So I'm creating my first proper VB program after a chap at work set me an interesting problem. This is for fun and my education only this code isn't going to go live!

The program essentially allows nurses to admit patients to the system then allows them to enter multiple observations (heart rate, blood pressure, temperature etc) which will appear on a grid view until the patient is then discharged.

The issue I'm facing is that obviously a patient can be admitted more than once, so when trying to display the observations

SELECT HR BP Temp etc WHERE Pat_ID = variable

may bring up observations from a different admission. I also can't limit it to todays entries only as entries may span midnight.

I'm currently using an "admission ID" to get round this problem which is a random number generated upon admission.

What I can't figure out is how to pass the variable from the admission form to the observation form in order to include it in the SQL string.

If anyone has any bright ideas, or indeed a more appropriate way to tackle this problem I'd be very grateful!

Thank you in advance,