SubForms

[Acc]

Hi there

Im new to this, so please forgive any errors i may make.

I need to create a subform to look up about 600 options, i created the
subform, and inserted a combo box to make my selections. but when i go the
next record in the main form, my selections from the subform stay the same
as what they were in the previous record, and when i make changes, it
changes the selections in all my records!! please help!

thank you

Melissa

 

[Golfinray]

You probably have something wrong in the basic design of your
mainform/subform. First off, mainform/subforms are designed to be one - to -
many relationships. That is, say, one realtor, many houses. So what you would
want is for one record in the mainform to show all the related information
about that record in the subform. In order to do this, your mainform/subform
have to be properly linked. Allow the form wizard to build the form for you
and then the subform wizard to build the sub for you and link them for you
and see if you get a better result. Also check that the table or query that
is the source of your forms is set up in a one - to - many relationship, if
not your basic design is flawed.