Unable to UPDATE tab form

[justme1310]

Hi everyone,

I'm trying to create a data-entry form from a medical screening form. The screening form has about 75 fields in 5 tables.

I have created a query to select all the fields which I populated 5 tab forms.

The problem is that I'm unable to enter data in the form.

Help anyone?

I can post the db, if it it allowed.


Thanks

Will

 

[PHV]

I'm unable to enter data in the form
Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[justme1310]

Hi PHV,

Thanks for the link - very detailed and useful reading..

The following is the SQL for the form

Could you take a look please and see what I'm missing?

SELECT tblCSCPatBio.*, tblCSCPatFlwUp.*, tblCSCPatLabRslt.*, tblCSCPatObGyHist.*, tblCVSPatExam.*
FROM (((tblCSCPatBio INNER JOIN tblCSCPatFlwUp ON tblCSCPatBio.PatientNo = tblCSCPatFlwUp.PatientNo) INNER JOIN tblCSCPatLabRslt ON (tblCSCPatBio.PatientNo = tblCSCPatLabRslt.PatientNo) AND (tblCSCPatFlwUp.PatientNo = tblCSCPatLabRslt.PatientNo)) INNER JOIN tblCSCPatObGyHist ON (tblCSCPatBio.PatientNo = tblCSCPatObGyHist.PatientNo) AND (tblCSCPatFlwUp.PatientNo = tblCSCPatObGyHist.PatientNo)) INNER JOIN tblCVSPatExam ON (tblCSCPatBio.PatientNo = tblCVSPatExam.PatientNo) AND (tblCSCPatFlwUp.PatientNo = tblCVSPatExam.PatientNo);

Appreciated


Will

 

[dRahme]

Hi, it looks like everything you have is 1:1, which could make updating a bit of a challenge.

Why not change your form around a bit and use tblCSCPatBio as the recordsource for your main form and place the biographical data there.

Keep the other four tabbed forms and link each one back to patientNo. Link Master / Child fields. Each form would have one table as its recordsource.

dRahme