Display lookup data on a form

[viperpurple]

Hey,

I am creating a database of all the equipment that we have and also a record of when it is checked for safety and inventory.

I would like to have the primary key (from another table) stored in the database but the description for each item been shown on the form to the user that relates to the primary key in the other table.

I have previously posted this on the Modules/Vba forum but i got no response so i thought i'd try a simple method on here.

Kind Regards


Adam

 

[pbaldy]

A common method is to have the user select the value from a combo box, which is bound to the key field. The row source of the combo would include the desired description field(s). In a textbox:

=ComboName.Column(x)

where x is the desired column number (0 based).

 

[viperpurple]

Thanks Paul,

I understand how that works, i am however wanting to select multiple items to do this with at the same time and then also let the user see what was previously selected when they revisit the form. Sorry i realise that i didn't make this totally clear.

I guess you could do this with Access 2010 as that allows for multi select combo boxes but i am working in Access 2003 and so don't have that option. I have tried it with a list box but i can't get it to store the data i have selected and then also nothing is selected once i come back to the record.

I'm hoping that this is fairly simple as currently i have been trying to get around the problem with VBA code and so far with only limited success.

Adam

 

[John Big Booty]

Have a look at this article concerning multi-select list boxes.

 

[viperpurple]

Thanks for that John, it gives me confidence that i seem to have been heading in the right direction. As i said earlier i posted this is the VBA forum as that's what i've been working on so far but with limited success. The below thread details my VBA code that i am trying to use.

http://www.access-programmers.co.uk/forums/showthread.php?t=200777

I'm monitoring either thread and so reply to either as i guess it's best to keep the VBA discussion in the VBA Forum.

Regards

Adam