hi guys i am a total newbie with vb6 can someone please help me with the code? ill give as give as much detail as i can.

here it goes, im building a simple application that queries from the database if its existing or not. if existing it would display the information required found in the database if not a message box will display that it doesn't exist.

here is a screenshot of the form i made


the user will input the patient no. and press the enter key then the rest of the information will be displayed if the record exist.

i have a database named "mdbCapz" with 4 tables "tblPatientFile", "tblImmuFile", "tblExamfile", and "tblVaccineFile".

*Primary key

tblPatientFile - FIELDS *PatNo, CName, FName, MName etc. <-Patient Info dispaly in caption
tblImmuFile - FIELDS *PatNo, *VCode, Dosage. <-Immunization Info display in flexgrid
tblExamfile - FIELDS *PatNo, Diag, Direct. <-Diagnosis Info display in flexgrid
tblVaccineFile - FIELDS *PatNo, *VCode, Description. <-Immunization Info display in flexgrid.

i hope you guys can help me because i dont even know where to start..