2 forms to update records in a table?

L

Linda RQ

Good Evening Everyone,

Access 2003 but will be opened on some computers in Access 2000. I am not
yet real comfortable with forms or the form verbiage so I will probably need
some guidance as to what information is needed to help me with this.

I have a form (**with some blank fields)inserted on my main form as a
subform but I would like to have a second subform for the user to enter
records on which the user will only enter the therapy that has equipment. I
want to label one subform Pt. Therapy with no Equipment, and the other one
will be Pt. Therapy with Equipment. Both forms records will populate
sfrmqry which updates the tblPatientTherapy.

Can this be done and if so, how?

Here are my tables.

tblPatientTherapy
PtThpyID
PtID_fk
ThpyTypeID_fk
PhysID_fk
EquipID_fk----**This is blank for some records which I know is not the best
design but for the level I am at, it works best for me except for now. <g>

tblPatients
PtID
PtLName
PtFName
PtMI

tblEquipmentType
EquipID
TagNum
Description
Model
Special Location
Active

tblTherapyType
TherapyTypeID
TherapyDesc
TherapyMultFactor

Thanks,
Linda
 
L

Linda RQ

I guess the lack of an answer means I need to go back to the drawing board
and create a couple of new tables. So...ok that's what I'm doing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to Shade a Field if Criteria Met 4
Get daily count from these table designs? 4
Selecting records to open in a subform 5
How to convert records in expression fields in Forms to a table? 12
Looking up existing records in several subforms all together 1
update a field in a table 1
Adding multiple subform records to a mail item in Access 1
Assign the records shown in a subform to a recordset 2

Top