Subform to requery Main form field (1 Viewer)
- Thread starter naobao
- Start date
- Local time
- Today, 03:51
- Joined
- Oct 29, 2018
- Messages
- 21,467
That didn't really answer my question; but if it's a true form/subform setup, did you have the correct fields in the Master/Child Linked Fields properties? If not, then I guess what you're asking is how to refresh the data. If so, you could try using the Requery command, maybe in the AfterUpdate event of the textbox on the main form.
- Local time
- Today, 03:51
- Joined
- Oct 29, 2018
- Messages
- 21,467
Try:
Code:
Me.Requery- Local time
- Today, 03:51
- Joined
- Oct 29, 2018
- Messages
- 21,467
Hi. Sorry to hear that. Unfortunately, I can't tell you why or what else to try since I have no idea what your database really looks like. You didn't tell us if the form is bound or if the subform is properly linked to the main form. I'm not even sure if you're expecting to see the data you entered on the main form to show up in the subform. Are you able to post a sample db?
- Local time
- Today, 03:51
- Joined
- Oct 29, 2018
- Messages
- 21,467
Thank you.
- Local time
- Today, 03:51
- Joined
- Oct 29, 2018
- Messages
- 21,467
Hi. I downloaded your sample file, but I'm getting an error because I don't have the same language pack installed as you. In any case, try using Me.Recalc in the button code instead of Me.Requery. Hope it helps...
- Local time
- Today, 03:51
- Joined
- Oct 29, 2018
- Messages
- 21,467
Hi. To requery, you use Requery. To recalculate, you use Recalc. In the demo you posted for me, you don't have anything on the main form. They are all subforms. The two smaller subforms are read only, so I imagine you want to update those because you can only update the bigger subform. I created a test file and tried using Recalc, and it worked for me. Since I can't really use your demo file, I can't test it.
- Local time
- Today, 03:51
- Joined
- Oct 29, 2018
- Messages
- 21,467
Hi. To do that, I was able to use Recalc. Try this demo and hopefully it will work for you.
- Local time
- Today, 03:51
- Joined
- Oct 29, 2018
- Messages
- 21,467
Hi. Either way, I still used Recalc. Check out the attached modified demo. You don't have to click the button, although I left it there.
- Local time
- Today, 03:51
- Joined
- Oct 29, 2018
- Messages
- 21,467
Hi. You're welcome. But, did you download either of the demos? Just curious...
Similar threads
