Search results

That's brilliant isladogs!!! It would have never cross my mind. Thank you so much!!!

You mean I should put the code under the AfterUpdate event and then put your suggestion under the OnClick to force AfterUpdate triggering? Am I close?

Because AfterUpdate only triggers if you enter a value by typing in and not if you choose it from a list. Same thing happens with OnDirty also (well almost).

I want to add a value to another table. This value won't be the same with the one picked by the combo but depending on it. But... It doesn't really matter what I want to do. It's when and how I can trigger the code to do it that matters. Let's say the combo picks full names from a client list...

Hi all, I have a combo in a form, where I enter values either by picking one from the list or writing a new one (on NotInList). Saved values may also change in the future. I want to trigger a procedure (besides saving the record) after saving a new value, or changing an existing one, without...

Well, I had 100% success (on subsequent clicking) by changing timer interval to 300. Thank you!!!

@ arnelgp @ theDBguy You guys are my Sunday heroes. Both suggestions seem to work perfectly. @ arnelgp Immediate click on another record in SubFormA makes SubFormB go to the first record. Should I raise the timer interval? Thank you!!! Thank you!!! Thank you all!!!

@ arnelgp @ theDBguy Thank you both for your answers. I'll try them both and I'll provide feedback.

Under the OnChange event of the textboxes there's a procedure that makes SubFormA "relist" data (the filter as you type procedure). Problem is, filtered SubFormA could show let's say 10 records. Picking on of them is triggering SubFormB's requery.

Thank you for your answer. "Select" would force SubFormB to load only selected records. I want it to load them all but display only last 30

Let’s go again MainForm is unbound and has only a few textboxes whose (imput) values filter SubFormA (bound to table). SubFormA and SubFormB (bound to another table) are connected via a textfield, call it ID. This way, when I pick a record form (filtered) SubFormA, SubFormB shows all...

Could be done but still don't know where to put the code.

You mean in the OnClick Event of the first subform? (tried it, doesn't work)

Of course proper referencing is needed, but isn't it depending on which event (of which control) I put the code in? Since I don't know where to put it I skipped the references.

Hi everyone, I have an unbound MainForm, bearing two subforms (SubFrmA, SubFrmB). The two subforms are related, so when I pick a record from SubFrmA data in SubFrmB changes showing related records. SubFrmB contains thousands of records related to every single record in SubFrmA, that’s why...

Thanks for your suggestions. It crossed my mind for a moment while I was searching for ways to overcome my issue, but it seemed too complicated, and it surely surpasses my skills. After all, I interpret any artist (or group) as an individual and I don't really mind whether an artist was a...

Why not... As soon as it is completed I have no problem sharing it. Of course I'll have to translate it a bit, 'cause all captions and messages would be in Greek, but I'll do it. I'm sure you'll have a good number of ideas on improving it or even correcting it, since I'm a novice in database...

Well, I'm designing this database mostly for personal use, but I want to it to be in such a way, anyone could use it. There's no way a user would remember to prefix the text in that combo, and even so, I think this would make things more complicated. So, I adapted the checkbox solution, and...

Thanks again for your answer. It seems like the only way to overcome my issue. Thought it would be something like that, but I wanted to avoid making things more complicated adding controls in the input form. However, it looks like it's the only way (at least for the time being). Thanks again...

Thank you for your answer. I'm sorry it doesn't provide any new idea or solution to my issue. I too of course keep my music by Artist and Folder (each artist a separate folder) on my disk. I also don't mind the "The" for the group name. But.. the way I split the new artist name in the...