R
Rocky
Let me see if I can give all the pertinent details:
I have a table with patient names and demographics. This table has a
subdatasheet for each procedure with associated risks and complications for
each patient, there may be multiple procedures per patient.
My first time through this process I created a query which used some of the
fields from the table and subdatasheet for a form
(frmDemographics/Procedure1). This form seems to work and when I wish to add
or edit records it presents the already stored records.
I created a second form with the intent of making it more user friendly, but
instead of using the query used the two tables as record sources. The tables
show up in the RecordSource window in the forms properties box, but none of
the previously entered records are present---in fact the record number shows
as zero.
I have to admit I'm just a bit lazy and would prefer not to have to redesign
the form using the query if there is some easy way out of this.
Any suggestions?
I have a table with patient names and demographics. This table has a
subdatasheet for each procedure with associated risks and complications for
each patient, there may be multiple procedures per patient.
My first time through this process I created a query which used some of the
fields from the table and subdatasheet for a form
(frmDemographics/Procedure1). This form seems to work and when I wish to add
or edit records it presents the already stored records.
I created a second form with the intent of making it more user friendly, but
instead of using the query used the two tables as record sources. The tables
show up in the RecordSource window in the forms properties box, but none of
the previously entered records are present---in fact the record number shows
as zero.
I have to admit I'm just a bit lazy and would prefer not to have to redesign
the form using the query if there is some easy way out of this.
Any suggestions?