entering and retriving data with combo box (with form and subform)

M

Mew

I have a form for student registration. All the fields are based on two
separate table. tblFamily and tblStudentsParticular.

Mother form:
frmFamily
FamilyID(Primary)
Address
Phone
Parent/Guardian'sName
etc

child form:
frmStudentsParticular
FamilyID(foreign)
StudentID(Primary)
NRIC/Passport
DOB
etc

I use a combo box to retrive data from the form for Parent/Guardian'sName.
Initially everything went smoothly. However, when I need to insert a new
student, whether with a new Family or from the current family, access will
always show an error. When I use the combo box, it does not retrive data any
more. However, when I change the subform to another record (family#2), all
the fields in mother form change together except Parent/Guardian'sName.

What should I do?
 

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

Combo Box Stops Working after Passing Data from Another Form 1
same subform used in two different forms 3
problems referencing a subform control? 1
Combo box search from main form to subform 1
Subform Combo filtered by Selected Parent Combo 3
Trouble Filtering a Sub Form With Combo Box Options 2
Disappearing Data 2
Searching a datasheet subform based on multiple criteria specified incombo boxes 0

Top