Windows 10: Access Database Problem

It's been SEVERAL years since I did any Access db programming and design. I do remember that the Wizard was often a helpful tool for things like List and Combo Boxes. No doubt you've been there, but thought I'd throw it out there in case you hadn't.

Good luck with your meeting.

 

Thanks nbcaldon for the pointer to use the Text rather than Value. This has fixed things. But as I can only access PersonTypeID.Text when that field has control I had to put the code for checking the constancy of it into the On Exit event. That leaves consistency code concerning another field in the routine I posted. As regards the Select function the first item is flagged by n = 0, the next by n = 1 etc. As far as I see things here the order is that which you have in the table that feeds the combo box. However, I have not yet succeeded if getting Selected(n) to return sense. So far I always got False even when I manually selected a value with the cursor. I do not need this as yet but if I get there I will get back to you.

best wishes

 

This is what I meant for a test:

For n = 0 To 1
MsgBox n & ": " & Me!Combo2.Selected(n)
Next n

Actually returns the numeric 0 or -1, but can be tested for True and False.

Looking a but more into MVFs, I cannot find any documentation to say what the Value property should return. I did find someone saying it returned a recordset, but I could not assign it successfully to a recordset object, so I suspect this might not be correct.

As regards where the data is stored, I have seen mention of hidden tables, but there are no simple hidden tables. It appears that the data is stored in a non-trivial way in the system tables, partly (but not entirely) in 'MSysComplexColumns'.

My recommendation would be that MVFs should only be used for simple applications where the wizards give you what you need and you do not need to get at the data in code. Otherwise, I think it is more manageable to stick to explicit many-to-many join tables and use subforms instead of multi-value combo boxes. I don't expect everyone to agree with this.

 

OK, I see, thanks. I agree with you about the multi-entry combo box. But the charity specified that they wanted the facility in several fields to multiple entry. As I am not involved in its running or direction and only got involved database wise on a voluntary basis, what they said goes.

Cheers