Search results

I'm now using the date Yes I can but remember it's not really an order. It'll take me some time to cut it down just to that form so maybe early next week if you don't mind

I had thought of displaying the description separately so hiding combo is a good idea.

I told you dates do my head in! I need to go into a darkened room and read this over a few times. Right so my combo uses the item id to do a look up. The item id is from the order table. I use it to display the correct description for the item and too allow the user to change it to another it...

Thanks for your patience!! And thanks to Minty for chirping in. I think I'm getting there but I'm not sure I've properly explained what I'm really after which has probably led to the confusion in my head. Maybe if I use an example. In the following the prefix combo shows the combo box. The...

So for a new record what value do you have in Me.TransactionDate. My equivalent field is NULL and it's falling over on this. I'm sure I'm getting my dates the wrong way round but I've checked this over and over. I'm sure I'll get there

I'm looking at it at the moment. I hate dealing with dates. To think I did wave theory 40 years ago at college and can't get my head round 2 dates! If you were thinking about this on your way back from holiday then I'm not giving up!

Thanks if you see my response to MajP I'm thinking that this is a long winded exercise as I firstly have to work out what changes I've made over the past week or 2. I should have probably kept track but haven't. Reading yours I get the sense I'm over complicating things again. Can I create the...

OK thanks. The problem I have at the moment is that as I've been developing I've made changes to several tables over the the past week or so. I can see what tables I've changed by sorting the objects into modified date order but not sure what changes I've made. I've also changed relationships...

I've been making some changing to tables in development, adding and deleting fields changing names etc etc. I now want to copy these into the user test environment. How do I do this. I don't want to lose the data just copy the table definition if you like. I tried using the import database and...

I tried this and I got blanks in the history. I must have messed the dates up so will look again as I like this method.

Yes I know which is effectively a yes/no box isn't it? IS orderdate <= datediscontinued is either a yes o a no? I think I'm missing the point if this works.

I could't get CJ_London's method to work probably because I din't fully appreciate what he was trying to tell me. To me it was a more flexible meth using a date to using a yes/no field but it was always going to end in does it appear on the list or not. Unfortunately if it was if not then the...

OK this sort of works in that for new records the item that has been discontinued is no longer in the list but for historic items it has to be otherwise it gets displayed as a blank if present historically. Which means that the user will see said discontinued item if if he wants to change one of...

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.