Vba subform recordsource not updating

Vba subform recordsource not updating

There are two ways that you can refresh the subform whenever the record in the main form changes: When you're using forms and subforms in Access, generally you link your form to your subform with one or more fields. In our example, we have a form called Orders that has a subform called "Order Details".

If you right-click on the subform object and select the properties, you should see that there are two subform properties called "Link Child Fields" and "Link Master Fields".

Below the text boxes is a subform (set to continuous form), which displays the search results. There's not much advantage to resetting the Record Source every time, although I'm not sure if there's much disadvantage either. Principally In the Chield Field /s we enter information from the main form that concerns the subform!The relation is: the first field from Link Master Fields corresponds to the first field from Link Chield Fields! I have another issue that i want one field in the subform to be a combo box when one of the value selected, rest of the fields should be changed to match the selected value. Not sure if this is what you are looking for, but here is what I did for a similar situation.I have had a look and your relationships hasn't been set correctly, so I have altered the database you have add to your thread, look at the relationships and you will see 1 to Many has been set. At some point look up Normalization your database that will help.I also removed the Incident Log table, pointless if you are adding for each day just add the field to the day register.

vba subform recordsource not updating-6vba subform recordsource not updating-10vba subform recordsource not updating-53

I know the problem is with the auto increment field that is not updating, any way to do it ?? In function of the link the query may be updatable or not! In the properties you have to flook for Link master field and link chield field properties!

Join our conversation (94 Comments).
Click Here To Leave Your Comment Vba subform recordsource not updating.


  1. 1

    The woman who wrote about AFF being a legit website for sex was wrong...the women OR couples succeed on that website. I REPEAT: ONLY women or couples and Black men succeed in finding sex on Adult Friend Single men are in the LESS THAN 1% of meeting anyone for sex on that website.

  2. 1

    Apologies if this has been asked / answered before.

  3. 1

    Recent years have seen an explosion of dating apps, and there seem to be incredibly niche ones launching every day. For some people, swiping through fellow singles and potential romantic partners is merely a bit of fun and a way to entertain themselves during TV ad breaks.

  4. 1

    She will have to deal with the resulting fears that may arise. Should she actively alter her behaviour, or her style of dress?

Leave a Reply

Your email address will not be published. Required fields are marked *