force a grid view

  • Thread starter Thread starter tim
  • Start date Start date
T

tim

i have a subform, within a subform, within a form, which
is a list of blood sub-tests, numbered 1-13. it's origin
looks like this (simplified)

StudyId TestId Value Low High

I want all 13 TestIds to show up in my subform for data
entry purposes. when using "continuous form/datasheet", i
can choose each of the 13 and the data is stored
correctly, but i'd rather see all 13, because some sub-
tests will be blank for some people. is this possible?

TIA--Tim
 
Set the properties of the subform containing the tests Default View =
Datasheet

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Hi Adrian,

That doesn't work because none of the tables are
previously populated. The table where teh results are
stored links out to the TestId table, with the 12 entries,
but I want these 12 entries to be visible with *no* data
having been entered. I really need to force my table to
automatically enter the 1 through 12 when i click onto
this subform.

Any other ideas?
 
The old problem of 'placeholder' records. In general creating empty records
is a bad idea. Wastes space, and the potential is that they never get
filled in. But in your case I can see the purpose. You might have to write
some code to create the set of empty records for a new test, with an ID for
each in your junction table, then display the result.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Further comment on this, since I just struck a similar problem in designing
a mailout system. If you set up a query linking the test table and the
junction table, but set the join to a left join, so you get all the test
records ( the names ) and only those records from the junction table, then
you automatically get a list with some ( or all ) blanks for the IDs of the
entities being tested. Then its just a matter of filling in the ones you
want.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top