I really appreciate your help, but I haven't really changed my question - just the code, as obviously I'm not clear on how to achieve my goal, which is:
1) to have a listbox display the name that corresponds to a stored number and, in the case of a null value, display a blank entry;and
2) to changed the value of the bound field to correspond to the listbox entry selected by the user.
The new code gets me much...
sartemieff
Last Activity: Mar 26 '10, 04:03 PM
Joined: Mar 19 '10
Location:
-
I get an error when I use that code...
I tried including that code and get the following error:
The SELECT statement includes a reserved word or an argument name that is misspelled or missing or the punctuation is incorrect.
Here is exact code:
...Code:SELECT TOP 1 NULL AS tblPHAs.Name FROM tblPHAs UNION SELECT tblPHAs.ID, tblPHAs.Name FROM tblPHAs ORDER
Leave a comment:
-
I actually figured out what part of the problem is: I was not including the "bound" column. I have changed my queries and the form properties so that the bound column (i.e., the ID) is selected and I am keeping it hidden by setting that column width to 0, but I still have the main problem of providing a choice in the listbox that corresponds to a null value in the bound field.Leave a comment:
-
How do I include a blank option in a listbox bound to an optional field?
I am using MS Access 2007 on an XP platform. I have forms (split and single) with listboxes. If a listbox is bound to a field that can contain a null, I would like the listbox to include a blank entry at the top of the list so it is readily apparent when the bound field contains a null and so that the user can deselect a value and revert to a null value. I would also like the listbox to display the entry that corresponds to the value of the bound...
No activity results to display
Leave a comment: