Search results

Thanks and I will when I've finished what I'm on. I've got around the problem any way but I'll send something over if I can recreate it!! Basically what I'm doing is I have a form bound to table x. One of the controls is a combo box with the country id from a table (countries!!). The record...

BIG EDIT HERE AS I'VE WORKED IT OUT!! I think there is a potential problem with RecordMatch. I found this when a self inflicted error rose it's ugly head. If there are any problems within RecorDMatch a boolean gets set to false and the code gets exited with RecordMatch = result. In the case of...

I will do. Just called to something more urgent. I'll send when I get back on it. I've got round the problem in the meantime but would be useful for future reference. I'll be back

Is there a list of what triggers what and also what you can and can't do in an event. I keep hitting the same problems so if there is a article on the subject would be great.

Fred was a value in the dropdown box (using select field from table etc). WHen I change it to fred2 i get NULL. If I blank it out I get the original.

OK one question. When I change say Fred to Fred2 this ultimately fails and is highlighted by a system error that it's not in the list. However it still triggers the change event and at that time contains NULL? I don't understand.

Thanks that's worth knowing!! On your page you have ".Value is that the former contains the current control data, and the latter contains the last saved " that doesn't explain the contents of my 3 examples. I presume mine are.values it being the default?

Ah OK thanks - wonder why it's been coded under the change event. When would you use the change event then?

I want to do something with a control if another control changes. The other control is a combo box. When it changes I want to store the changed value in another control. There is a reason!! So I bascially have Me.atextcontrol = Me.acombocontrol.Column(1) The combo box displays a list of...

OK I'm applying it some more complex forms regarding validation etc etc. I'm pretty sure I know what's going on except for sub Form_Current. Is this just opening and closing the table that the form is bound to using the ID. I have one table with it's own ID and IDs from other tables and want to...

Just had a quick look and from first test looks good. THanks. I'll give it more of a hammering and then apply to one of the more complex forms to see how it fares. Thanks for your help!

OK I'll check that out, probably next week now, but in the meantime the attached seems to work. The idea was stolen from this link! https://access-programmers.co.uk/forums/showthread.php?t=38364 You have to save the record first or undo. It's slightly more work involved for the user but for the...

I'm coming t the same conclusion!! I have found a demo that forces the user to save the record by clicking a button but I can just imagine there will be one case where it doesn't work. Think I've spent to much time on this, as have you, so will pick the version that is most likely to happen and...

Yes it does and when you try and skip to a different record with the combo box you get an error and the value is set back to what it was. If you then skip to a new record the updateby and on are updated when effectively the record hasn't changed

Thanks so much. I've just dug out an old laptop which has an earlier version but I think it's steam driven and it's taken 30 minutes to boot it up and get chrome to open!!

I hope ghudson is still about!! I'm having a load of problems validating a form and then skipping to the enxt record and this seems like it may be of help but I've got access 2016 and it's refusing to open a previous version Any chance in someone that has an old version of access saving this as...

Yeah I think you got them but this still doesn't quite work. This scenario is unlikely to happen on this form but it could on others. So user goes in and blanks the description out only. He then tries using the combo box to skip to another record. The logic tells him there is an error and sets...

OK this almost works but not quite. What do I want? This is a simple form but I have more complex ones with validation on more than 1 field. The user can make changes to none or more of the the controls on each form. He can then move off the current record by using one of the navigation...

still not quite there. i'll add explanation tomorrow as i'm ready to drop.

Yes. In a nutshell all the validation works but those 2 fields are only updated when the combo box is used to select another record. And they are always updated. They should only be updated if the record has been changed. I'll take a lok at the attachment in your next post