I use a form/subform combination to allow entry of stock whereabouts. The main form is an item description; each subform record contains (amongst other things) a field, LOCN, indicating the item's location. Earlier records in the subform report where the item has been in the past. Currently, LOCNID is a text box into which data is entered manually.
I’d like to be able to limit data entry in LOCN to locations listed in tbl_Locations.LOCID , where LOCNID is related to LOCID via a many to one relationship.
There are several hundred records in tbl_Locations, far too many to have LOCNID set up as a list box based on LOCID. Trying to make it a combo box is OK so long as a validation rule isn’t set. I gather from various web searches that this is a well known restriction.
Ideally, I’d like to be able to start typing data into LOCNID such that when the first character is entered a two column list box appears limited to the values of LOCID that start with that character. (The second column gives much more detail, letting the user know whether they’re making the right selection). If that produces too long a list then I’d like to be able to enter a second, and even a third, character in the LOCNIN box, to produce a list of just a few fields from which the user can select the one required.
This can’t conceivably be a new requirement but a web search hasn’t uncovered a solution. Would someone please be able to point me in the right direction?
I'm using Access 2007 - no need to worry about earlier versions. I have some VBA experience, although more with Excel than with Access.
TIA John
I’d like to be able to limit data entry in LOCN to locations listed in tbl_Locations.LOCID , where LOCNID is related to LOCID via a many to one relationship.
There are several hundred records in tbl_Locations, far too many to have LOCNID set up as a list box based on LOCID. Trying to make it a combo box is OK so long as a validation rule isn’t set. I gather from various web searches that this is a well known restriction.
Ideally, I’d like to be able to start typing data into LOCNID such that when the first character is entered a two column list box appears limited to the values of LOCID that start with that character. (The second column gives much more detail, letting the user know whether they’re making the right selection). If that produces too long a list then I’d like to be able to enter a second, and even a third, character in the LOCNIN box, to produce a list of just a few fields from which the user can select the one required.
This can’t conceivably be a new requirement but a web search hasn’t uncovered a solution. Would someone please be able to point me in the right direction?
I'm using Access 2007 - no need to worry about earlier versions. I have some VBA experience, although more with Excel than with Access.
TIA John
