List Box Help

[vcarrill]

Hello,

I would like for the Process Area and Description to auto populate based on what I enter under Cert Code.

I am unsure how to do this with a List Box?

Appreciate the support, thank you

 

[CJ_London]

Do you mean listbox or combobox? A list box can show the values anyway

And when you say populate - do you mean to simply display the values or are you wanting to populate fields in a table? If the latter, why?

 

[vcarrill]

What I mean is, Id like to offer the certs as a list and when a particular cert is selected, I need the Process Area and Description to be tied to it so it can be seen upon selection. At some point I would like to query which certs are available by area, etc.

 

[CJ_London]

still not clear what you mean

but with a listbox you would have a rowsource along the lines of

SELECT CertPK, Cert, ProcessArea, CertDescription
FROM tblCerts

Note I have removed spaces and renamed fields (you need a primary key field (certPK) and Description is a reserved word

then in your listbox control, set the column widths as required, hiding the CertPK column (set width to 0)

 

[bob fitz]

What I mean is, Id like to offer the certs as a list and when a particular cert is selected, I need the Process Area and Description to be tied to it so it can be seen upon selection. At some point I would like to query which certs are available by area, etc.

You could have a combobox from which you choose a cert. You could have the other details as hidden coloumns in the combobox. A textbox on the form could reference the appropriate column of the combobox to return the required data.

 

[SHANEMAC51]

What I mean is, Id like to offer the certs as a list and when a particular cert is selected, I need the Process Area and Description to be tied to it so it can be seen upon selection. At some point I would like to query which certs are available by area, etc.

when I need to see several fields when selecting (often long ones), I use a dialog form instead of a list with the ability to select by any field, including by partial value and a combination of several fields

 

[vcarrill]

Do you mean listbox or combobox? A list box can show the values anyway

And when you say populate - do you mean to simply display the values or are you wanting to populate fields in a table? If the latter, why?

Display the values. What I am trying to do is create a repository to capture certifications by employee. So when a particular cert is chosen, the end user needs to see area and description.

 

[CJ_London]

from your description you need 3 tables

tblEmployees
empPK
empFirstName
empLastName
...
...

tblCertificates
CertPK
Cert
ProcessArea
CertDescription

and finally to join these together

tblEmployeeCerts
empCertPK
empFK
CertFK
CertDate
ExpDate

so per my example post#4 on a form you would use that rowsource in a combo for the CertFK field in tblEmployeeCerts