So you have a *completely new table*, unrelated to any other tables?
Again: please open the Query that you are using as the recordsource of the
Form. Open it in SQL view (View... SQL). Post the SQL text here.
My *guess in the total absence of evidence* is that you have two tables in a
query and that the join between them is incorrect, causing no records to be
returned.
Typically you would NOT display multiple tables' data on one form, instead
using a Form with Subforms - but then I know nothing about your tables orthe
structure and relationships of the data within them.
I do have a completely new table, but it is related to the other
existing table. Here's the deal: I have 7 tables containing various
data of patient records: ID (auto numbered), Subject Code, several
fields of date/time stamps of admissions, discharges, transfers, etc.
It's a lot of data. The primary key of each table is the Subject
Code, although there is one main table with the primary key being the
auto-number ID (this table does also include the Subject Code field).
The six other tables have a 1:1 relationship to the main table,
linking the Subject Codes. (I did it this way because the instructor
in the certifcation class said every day for four weeks - "you'll
never have enough tables! people have problems because they never make
enough tables!") Should all the tables be related to each other's
SbjCd, like one big spider web?
Here is the SQL text (is this really what you wanted?) There are seven
tables in the query, all related as described above:
SELECT tblTransferredTraumaPatientsIMPORT.ID,
tblTransferredTraumaPatientsIMPORT.[Subject Code],
tblTransferredTraumaPatientsIMPORT.[Date of Admission],
tblTransferredTraumaPatientsIMPORT.Class,
tblTransferredTraumaPatientsIMPORT.ISS,
tblTransferredTraumaPatientsIMPORT.[Mechanism of Injury],
tblTransferredTraumaPatientsIMPORT.[Intubated Prior to Arrival],
tblTransferredTraumaPatientsIMPORT.Age,
tblTransferredTraumaPatientsIMPORT.Gender,
tblTransferredTraumaPatientsIMPORT.[DateTime of Injury],
tblTransferredTraumaPatientsIMPORT.[Date/Time Arrived],
tblTransferredTraumaPatientsIMPORT.[DateTime Registered in ED],
tblTransferredTraumaPatientsIMPORT.[Date/Time Out of ED],
tblTransferredTraumaPatientsIMPORT.Disposition,
tblTransferredTraumaPatientsIMPORT.[Date/Time in CT],
tblTransferredTraumaPatientsIMPORT.[Date/Time Available in CareWeb],
tblTransferredTraumaPatientsIMPORT.[Date/Time of Reading],
tblTransferredTraumaPatientsIMPORT.[Date/Time of Discharge],
tblOSHCTEvaluations.Head AS tblOSHCTEvaluations_Head,
tblOSHCTEvaluations.[Max/Fac] AS [tblOSHCTEvaluations_Max/Fac],
tblOSHCTEvaluations.Cspine AS tblOSHCTEvaluations_Cspine,
tblOSHCTEvaluations.CTA AS tblOSHCTEvaluations_CTA,
tblOSHCTEvaluations.Chest AS tblOSHCTEvaluations_Chest,
tblOSHCTEvaluations.[Abdomen/Pelvis] AS [tblOSHCTEvaluations_Abdomen/
Pelvis], tblOSHCTEvaluations.[Bony Pelvis] AS
[tblOSHCTEvaluations_Bony Pelvis], tblOSHCTEvaluations.Extremity AS
tblOSHCTEvaluations_Extremity, tblOSHCTEvaluations.Other AS
tblOSHCTEvaluations_Other, tblOSHCTEvaluations.[OSH IV Contrast] AS
[tblOSHCTEvaluations_OSH IV Contrast], tblOSHCTEvaluations.Dose AS
tblOSHCTEvaluations_Dose, tblUMCTEvaluations.Head AS
tblUMCTEvaluations_Head, tblUMCTEvaluations.[Max/Fac] AS
[tblUMCTEvaluations_Max/Fac], tblUMCTEvaluations.Cspine AS
tblUMCTEvaluations_Cspine, tblUMCTEvaluations.CTA AS
tblUMCTEvaluations_CTA, tblUMCTEvaluations.Chest AS
tblUMCTEvaluations_Chest, tblUMCTEvaluations.[Abdomen/Pelvis] AS
[tblUMCTEvaluations_Abdomen/Pelvis], tblUMCTEvaluations.[Bony Pelvis]
AS [tblUMCTEvaluations_Bony Pelvis], tblUMCTEvaluations.Extremity AS
tblUMCTEvaluations_Extremity, tblUMCTEvaluations.Other AS
tblUMCTEvaluations_Other, tblUMCTEvaluations.[OSH IV Contrast] AS
[tblUMCTEvaluations_OSH IV Contrast], tblUMCTEvaluations.Dose AS
tblUMCTEvaluations_Dose, tblUMCTEvaluations.[Total CT mSievert 24hrs
Post-Admission], tblReasonsForRepeatCTs.Head AS
tblReasonsForRepeatCTs_Head, tblReasonsForRepeatCTs.[Max/Fac] AS
[tblReasonsForRepeatCTs_Max/Fac], tblReasonsForRepeatCTs.Cspine AS
tblReasonsForRepeatCTs_Cspine, tblReasonsForRepeatCTs.CTA AS
tblReasonsForRepeatCTs_CTA, tblReasonsForRepeatCTs.Chest AS
tblReasonsForRepeatCTs_Chest, tblReasonsForRepeatCTs.[Abdomin/Pelvis]
AS [tblReasonsForRepeatCTs_Abdomin/Pelvis], tblReasonsForRepeatCTs.
[Bony Pelvis] AS [tblReasonsForRepeatCTs_Bony Pelvis],
tblReasonsForRepeatCTs.Extremity AS tblReasonsForRepeatCTs_Extremity,
tblReasonsForRepeatCTs.Other AS tblReasonsForRepeatCTs_Other,
tblMissedInjuries.[Discrepancy Btwn Initial and Consult],
tblMissedInjuries.Head AS tblMissedInjuries_Head, tblMissedInjuries.
[Max/Fac] AS [tblMissedInjuries_Max/Fac], tblMissedInjuries.Cspine AS
tblMissedInjuries_Cspine, tblMissedInjuries.CTA AS
tblMissedInjuries_CTA, tblMissedInjuries.Chest AS
tblMissedInjuries_Chest, tblMissedInjuries.[Abdomin/Pelvis] AS
[tblMissedInjuries_Abdomin/Pelvis], tblMissedInjuries.[Bony Pelvis] AS
[tblMissedInjuries_Bony Pelvis], tblMissedInjuries.Extremity AS
tblMissedInjuries_Extremity, tblMissedInjuries.Other AS
tblMissedInjuries_Other, tblRenalFunction.BaselineCreatinine,
tblRenalFunction.[Max Creatinine in 7 Days Post-Admission],
tblRenalFunction.[Date of Max Creatinine], tblRenalFunction.[Max
Creatinine During Hospitalization], tblRenalFunction.Dialysis,
tblRenalFunction.[Date Dialysis Intiated], tblHospitalOutcome.
[Discharged Alive], tblHospitalOutcome.Deceased
FROM (((((tblTransferredTraumaPatientsIMPORT INNER JOIN
tblMissedInjuries ON tblTransferredTraumaPatientsIMPORT.[Subject Code]
= tblMissedInjuries.[Subject Code]) INNER JOIN tblOSHCTEvaluations ON
tblTransferredTraumaPatientsIMPORT.[Subject Code] =
tblOSHCTEvaluations.[Subject Code]) INNER JOIN tblReasonsForRepeatCTs
ON tblTransferredTraumaPatientsIMPORT.[Subject Code] =
tblReasonsForRepeatCTs.[Subject Code]) INNER JOIN tblRenalFunction ON
tblTransferredTraumaPatientsIMPORT.[Subject Code] = tblRenalFunction.
[Subject Code]) INNER JOIN tblUMCTEvaluations ON
tblTransferredTraumaPatientsIMPORT.[Subject Code] = tblUMCTEvaluations.
[Subject Code]) INNER JOIN tblHospitalOutcome ON
tblTransferredTraumaPatientsIMPORT.[Subject Code] = tblHospitalOutcome.
[Subject Code];
