LookUp Default for Database Table

[Heaven4ever2]

I have a combobox pointing to a Dataverse Table named Solicitation.  On the Default I have added this formula, which takes me to the record. I can see it's found because of the data below the formula field, as you can see in the first screenshot. However, it does not show up as default:

LookUp(Solicitations, 'Solicitation Id'=SolicitationNumberNeeded.Text)

Solicitations is the table, 'Solicitation ID' is the field, SolicitationNumberNeeded.Text is the Solicitation ID number for the Solicitation record I'm trying to bring up.

The idea is that when the SolicitationNumberNeeded.Text changes, the default value of the Combobox Solicitation will change to the one with that Solicitation ID.  Thank you for your help.

[BCBuizer · Accepted solution]

Hi @Heaven4ever2 ,

Please use this code to set the DefaultSelectedItems property, rather than the deprecated Default property.

[Heaven4ever2]

Thank you so much, @BCBuizer!  That worked 🙂

[BCBuizer]

Hi @Heaven4ever2 ,

Glad to have been of help. Can you please mark the correct post as the solution to your question for the benefit of the community?

[Heaven4ever2]

Hi @BCBuizer 

I have corrected it.  I'm new at this, as you can tell 😂.  Thanks again 🙂