Recent content by emalrola

Thanks. The delete doesn't seem to work. Have decided to write a function to call on-click which tests if the clicked value is already selected and if so, to clear the selection. This seems most consistent with the user-interface (ie; how simple and extended multi-select work) Just wanted...

I have it set to none and then when the user runs the form, he seems to be unable to deselect once he has selected. How does the user select 'no value'?

I'm sure this is obvious, but I don't have the experience and can't find any examples in the foruums/online help. So, apologies in advance for such a trivial question! I have various list boxes on my form which populate optional (unbound) controls. Once the user has selected one, if they then...

Having looked at your data, it strikes me that the codes ending in 'X' actually mean something else. In my experience, users tend to adapt codes to represent data if they can't get the functionality they want. I would check with your users why exactly they want the X to come first - if, say ...

Thanks for a swift reply! Yes, my underlying database is absolutely normalised. (I have been normalising data for 20 years and am fully confident in this area! Its just the VBA I'm not sure about...) It may be that I just can't do what I need to with VBA/forms - I tend to favour generic...

I have a form with lots of control fields called things like session1 id, session1 start time, session2 id, session 2 start time etc I have a table which I query to poulate these fields. I wanted to knock together a quick generic function where I could set the values of all the relevant...