Combo box in form, showing not only record value but also text based on a correspondence table

[cesarone82]

Hi,

I was successful in creating a combo box that has a list of values based on another table (code , description) this is when i chose the box to select the value to input.
The problem is that when the combo box is not selected i can only see the (code) while i d like to see both of the exactly as when i ahve the combo box selected





It is the frm_projclients in the attached databaseProgetti.zip

[Welshgasman]

You generally store the first value and show the second. Least that is how I do it, with the first field being the bound field.
User should not care what the bound field is, but what it represents, which is the descriptive value.

Start looking at YouTube for videos about Access, plenty on there which are very helpful.

https://www.youtube.com/results?sear...=access+combos and one that is pertinent https://www.youtube.com/watch?v=yCLAsFbQEfg

[Bob Fitz]

It is the frm_projclients in the attached databaseProgetti.zip

There is no form with that name in the file

[Welshgasman]

There is no form with that name in the file

Probably tbl_projclienti Bob?

[Bob Fitz]

Probably tbl_projclienti Bob?

Well that's what I thought too, but I can't see a combo on that form

[cesarone82]

Sorry here the correct one, the form is frm_projcons

https://wetransfer.com/downloads/3feb850931862ae5e977083ed216addd20231129141953/480c7026fbb706ab66b43d94b422be4920231129141953/5677a9

[mike60smart]

Hi
In tblProjectProf I changed the field Type to be ProjTypeID
I made the field a textbox and NOT a Lookup Field (Google the Evils of Lookup Fields in Access Tables)

In tblProfType I added a field named ProjectTypeID - PK - Autonumber
Removed the field Type as it was just a Number DataType

I then linked the two table on ProjTypeID

It now works as it should