Recent content by Ugurovic

An example would be great Vinzz :-):-) Regards Ugurovic.

Lpurvis, Thanks for your advice, but your solution also do not cover completely my question to undo changes to subrecords. Once changes made, how to undo and get the previous value of the record. Yes my subform and mainform is bounded, and I think it will stay like that. Your solution is...

Hello I attached my DB, without some data and other forms. With the "NEW" button, I make a new record. With "MODIFY" button I want to make changes to subform and mainform. But when I press close, I want that the changes made to be cancelled and the records returns to his previous version...

Thank you, Your code is only working on the first record of the subform and not on the rest of it. Is it because I use continous forms, I think so. Is there a possibility to perform a loop of all the records of the subform...?? Regards Ugurovic

Ok. Is there any possible way to undo changes on a subform not using unbound fields AND the escape button? If not, I'm gonna kill myself. Regards Ugurovic

gooooosh, is it that really hard? pppffffffffff The stephen lebans example of commandbars form didn't impressed me that much. Do you got another example? Thanks Kind regards Ugurovic

But how to save the records of the unbound fields. What code do I need? CurrentDb.... .Edit and so on, I don't know the code, can someone put a clear and code on how to do it. Thank you. Kind regards Ugurovic

I want to undo changes made to the subform. I think it also works with .Edit. But is it possible that I make my Mainform Bounded to the table and write edited unbounded fields of the subform by .Edit, currentdb... I don't know the exact code to write unbounded fiels of a form to a table...

THanks for your reply. But it doesn't work. You can only refer to events of the subform and not what's in the form. What expression does refer to a button on the subform? Kind regards Ugurovic

Hello I think the title explains a lot. 1. How to refer from mainform-button to subform-button AND execute whats underneath that button? Setfocus->Execute. Button on subform will be 'unvisiable'. Thanks in advance Ugurovic

Hello Can someone attach a file where a form and subform is connected BUT where the subform is unbound. In het "Unbound.zip" it is just 1 form and not a subform. Thank You Kind regards Ugurovic

No that doesn't... I need the code to undo the strSQL function so I can search in the listbox via another field... undo strSQL, that's what I need.. Kind regards U.

Anybody who can solve my issue? Kind regards Ugurovic

Ok, I have 2 situations 1. I have a table 'Names'. In the rowsource of the properties of my list I have a SQL that filters records of the listbox via an extern field. When I put a value in this field, it filters records on this list based on the table. Ok? So my suggestion was, I have...

By locking I mean that the rowsource sticks locked by strSQL I've done with VBA (see above), so I need another function to clear this rowsource so that I get the whole table in my list and not the one I've searched for in my strSQL in VBA. How the clear rowsource strSQL, any idea? Is there a...