Subform

[Guest]

I have a main form that has more than one command button that open a subform.
Each record has so much information I decided to break the info up into
subforms. The main form and subform are linked by the ID #.

Each subform opens to the ID #. The suform can have multiple entries by
date. They are setup in the continuous form view so you can see the multiple
records. For each record you have to key in the appropriate ID #. Is there
a way to avoid keying the ID #? I would like the ID # to automatically fill
in based on the linked ID field.

For instance, in my main screen, I select ID 123 to add more info. I click
on one of my command buttons to update record. In order to key the record, I
have to key in the ID # of 123. I would like to avoid that if possible.

Thanks,
JS

 

[Roger Carlson]

I would embed the subform IN the main form and then use Parent/Child linking
of the subform control to keep the main form and sub form synchronized. If
you need to have several subforms, put each on a separate tab of a Tab
Control.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thank you. I will change.

I would embed the subform IN the main form and then use Parent/Child linking
of the subform control to keep the main form and sub form synchronized. If
you need to have several subforms, put each on a separate tab of a Tab
Control.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L