If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SubForms
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 |
#2
|
|||
|
|||
SubForms
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. "Acc" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|