Re: purpose of subform?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Gina,

1. - 3. The combo box on the Main Form should be unbound. You do not need
to save the value for anything.
got it.

4. Subform should be in continuous view and attached to the Main Form (Link
Fields) StudentID. Then the field Student Subject should be a combo box
using the tblSubjects as the Record Source and the value should be bound to
the ssStudentSubject.
-how do i (or when in the wizard do i) link the subform to the main form?
-tried setting "Source object" for subform to main form but when i try to
link child/master fields, get message stating "cant link unbound forms"

tried all above 1)new record is created in tblStudentSubject w/ correct
subject from cbo in subform but 2)studentID is blank.

.

Relevant Pages

  • Re: purpose of subform?
    ... Then the field Student Subject should be a combo box ... using the tblSubjects as the Record Source and the value should be bound to ... link child/master fields, get message stating "cant link unbound forms" ... subject from cbo in subform but 2)studentID is blank. ...
    (microsoft.public.access.forms)
  • Re: purpose of subform?
    ... Then the field Student Subject should be a combo ... using the tblSubjects as the Record Source and the value should be ... subject from cbo in subform but 2)studentID is blank. ...
    (microsoft.public.access.forms)
  • Re: autonumber on form??
    ... > So you are telling me, to fix the subform I need to rebuild it now that I ... A subform control, designed as a ... >> record source) would then be placed on the main form, ... >> related orders for that customer. ...
    (microsoft.public.access.gettingstarted)
  • RE: SourceObject and RecordSource
    ... It would be much better if you used one subform with a query as the record ... main reason I'm setting RecordSource at runtime is to optimize record access. ... Load event, but won't setting RecordSource itself call Current? ... to change the record source. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Prob with mainform cbo & subform
    ... subform is redundant, that's why the subform does not have this field. ... > relationship between the data in the main form's record source, ... If you are assigning the row source of the combobox ...
    (microsoft.public.access.formscoding)