Requering the subform shown on main form

[vazdajic]

Hello everybody.



I don't know how to requery a subform to show me data in real time based on input in the main form.. I have linked REQUEST NO (master and child fields are both set to REQUEST NO) and I see the data but after I save the record and go one record back and forward to see current record again...

[ranman256]

if the name of your subform is subF, then
subF.requery

[vazdajic]

Hello.. It doesn't work.. Hm.. Never mind.. I will leave it as it is..

Thanks.

[vicsaccess]

not sure why it didn't work vazdajic, what ranman gave should work but i would suggest putting it in the after update event of the mainform request NO. that way you are triggering the requery after you enter the value.

[vazdajic]

It just doesn't work, unless I go a record BACK and FORWARD.. Then, everything appears.. Hm..

If you have time, please take a look on the DATABASE ATTACHED

[vicsaccess]

Requery problems.zip
made a few changes including the requery. it does bring up all the reports but not the one you are working on.

[vazdajic]

Great Job!

What you did is is what I wanted;
when I enter request no and click on report no combo, all reports related to that request appear (I don't have to go BACK and FWD).. Then, when I enter report no and click revision combo, a list updates with how many times that current report I'm working on has been checked and by who etc...

Thank you so much!!!!!!!

[vicsaccess]

Glad to help but do you see what was done so that you will be able to do it? look at the query for the subform, it now points to the text box for criteria and then the afterupdate event of the text box refreshes the subform.

[vazdajic]

Thanks... I see what you have done.. My mistake was, I rerequired it separately which used to show me an error.. But, you rerequired both list on the main form and the subform together..

Thank you once again..