How to get input for a particular item selected on list box

[tushar]

Hi,

I am a newbie in Access, need some help.

I have to get two information from user
1. Program Name
2. Version number for program

Since program names for system is always known, I want to give user the option of selecting the program from list, and then let him enter the version number.

How can i achieve it.

Also, One request, since I am basically a mainframe programmer, request you to reply in terms understandable by layman.

Regards,
Tushar

 

[tushar]

Hi,

For the problem, I decided to have a list box & a text box.
Whenever a selection was made, the text box will appear with spaces. In case of multi selection, the value in text box will be initialized.

But I realised, that in this design, it will be difficult to rectify the mistake, if committed by user.

So, I thought, it will be better, if I throw a table with two columns, one having the program name, and another empty for user to enter the value.

So i would like to know from other people, how to do it.

Please note - I am using Access 2003.

Regards,
Tushar

 

[Trevor G]

Tushar,

Do you have a table with the program names?

If yes create a new table say something like tblPrograms

Then create a new field called ProgramName and in the datatype select to use the Lookup Wizard then you can look for the table which has the program name once you go through the wizard to the end it will then give you a drop down with the list of programs in datasheet view of the table.

Then just add another field called programversion with either a text entry or number entry.

That will then give you a table with 2 Fields which your users can access selecting the program name and assigning it a version number.