Search results

See my reply t your first post. I've changed as you have suggested but I'm still getting he same problem. If the date is in the past the record quite rightly doesn't show in the combo box, nut the combo box is now blank for the item that was discontinued. Maybe I wasn't clear in my example...

I've very quickly tried this so I now have as my row source SELECT Items.ID, Items.Description FROM Items WHERE not (me.dateadded>nz(datediscontinued,me.dateadded)) Dateadded is a new field on the the bound table and also a control on the form itself. datediscontinued is a new field on the...

Ok, I like that idea. My example isn't actually an order as I was making the post easier to understand and, the main reason, easier for me to get my point across! This discontinued field appears all over the place in the system so I will go down the date route. There isn't actually a date on the...

Thanks. I'll give it a go if I can work out what it should be in my system!!

Not quite sure I understand what you are saying. I was simplifying what I have in my original post but I have actually got a query that includes current and discontinued in my record source for the form. Even in my example the table items will have both anyway. Are you suggesting therefore to...

This isn't exactly what I've go tut it's easier to explain this way! I have 2 tables. Items and Orders. Some of the items are longer and have been discontinued. The order form it is bound to a table that contains the item id. I have a combo box. The control source is the item ID from the order...

pbaldy and minty I've tried to replicate my scenario but the behaviour is as pbaldy says. I don't have the original as I changed it beyond belief to get it to work. So thanks for all the help.

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...