Refreshing data in a subform drawn from a query

[khayward]

Hi guys,
I haven't posted here in a while, I have received lots of help and advice in the past. I'm working on a new version of an 'MRP' that I've been trying to put together for some time and have a few bugs. This first one looks like it should be simple but I've done a bunch of research and either I'm being dense or it's not as simple as I thought.
I have a series of tabbed subforms. One of the subforms pulls from a query that in turn is fed by data from a table bound to another of the tabbed subforms (A completely different issue to solve another time). If I change the value in the second subform and then go to the first one the data in it remains unchanged, but if I press F5 the data in the subform refreshes and I get the new values.
I don't want to have to press F5. I have tried a couple of things that I found after searching around, such as me.Requery for various events and wonder if I am just not understanding how to apply these fixes.

Any advice?

[orange]

How exactly do you do this?

If I change the value in the second subform

Do you have some code to validate that new value? If yes, can you post that code?

[khayward]

BCMRP1.zipThe second subform is just a continuous form where I can enter numerical values. Those values then go through a series of queries (Probably very clumsy) and the last query output is displayed on the first form, the one I want to 'refresh' without hitting F5. There's no code, just the tables and queries.
In the attached file the main form is frmAssemblies, the subforms are subfrmAssyPricing (Contains the query output) and subfrmRFQQTY (Where the numeric values are entered).

[pbaldy]

I'm on an iPad right now so can't look at the sample, but try requerying the first subform from the after update event of the second. Syntax here if needed:

http://www.theaccessweb.com/forms/frm0031.htm

[mike60smart]

Hi

You say "In the attached file the main form is frmAssemblies, the subforms are subfrmAssyPricing (Contains the query output) and subfrmRFQQTY (Where the numeric values are entered)."

So you are using frmRFQQTY to enter values and which Form do you want to Refresh?

[mike60smart]

Hi

Best I can do is now when you enter data into the First Subform and then click into the Assembly Pricing Subform the values refresh

[khayward]

Thanks everyone for your replies, with the long weekend I forgot to check back for responses. Thanks Mike for the sample with the procedure - that's what was hanging me up is that I'm unfamiliar with writing those out and what I found in books and on web pages didn't include those parts, in fact most of them just had 'me.requery' as the whole thing.

Refreshing the data in that subform was all I needed at the moment, I know the way I have things set up is clunky and a bit slow. I am slowly teaching myself these things. I think I have tables and normalization down and am now trying to get the hang of something more than a select query. What's throwing me off a bit is calculations. Anyhoo, a topic for another post, thanks for the assistance!