Re-Post-Refreshing Form with Multiple Forms and Fields

[nutmeg]

Would anyone be able to assist with this challenge. Thank you.

I have a main screen form that allows entry to start from that location. It
has four subforms and some other fields that are picked from other locations
to filter the record. My challenge is it does not Refresh right away. I
have tried putting Refresh and Repaint etc in the main form code but it still
doesn't refresh. I put a Refresh button on it and that works but it's slow.

Can anyone tell me what would be a more efficient method to get this screen
to refresh right away.

Thank you,

 

[boblarson]

Refresh and Repaint are not what you want. You want REQUERY. Without more
detailed information I can't tell you exactly where you should put this.

What is it that you are needing to have requeried and why? Is it the main
form, the subforms, what?
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[nutmeg]

Good afternoon,

Thank you for responding. I have tried Requery but to no avail so I think I
must have it in the wrong place. Sorry, I didn't know exactly how much to
post.

I have a main form, it has an address search box linked on a folio number
that stores information on a calls table; also shown on the main form are
combox boxes that have dropdown lists related to the address that is picked
and each one of those needs to store the value on the calls table. But what
happens is: you pick the address, you pick the first dropdown info; you pick
the second dropdown info and you want the whole form to save the data back to
the calls table and then go to the next form for entry. What happens is that
it stays on the record and doesn't refresh until you press a refresh button
that I put on the main form, which isn't exactly what I would like it to do.

When using Requery, where is it positioned in the code?

Hope this is more useful to you to assist.

Thank you,