Combo Box Problem

[ekta]

Hi,

I have a subform which has a combo box (Opportunity_ID). When the user selects a field from the combo box the rest of the fields in the subform are populated automatically.
My question is. Is there a way that when the user opens a form and sees the subform, the combo box should be visible just as a normal text box. Only when the user wants to add a new record in the subform the text box should change to a combo box.
I dont know if this can be done.
Please help.

Thanx so much in advance
Ekta

 

[Fornatian]

I have not seen an example of exactly that, however the attached example - open form Table2 has code that is part solution, by toggling the properties of two copies of the same field you can replicate a similar feel.

 

[ekta]

Hi

Thanx so much for the code. It works but I have one problem. In my combo box I do not display the OpportunityID because for the user it makes no sense. Instead I display opportunity name.

After adding the code which you gave me I see the combo box only when I add a new record, which is exactly what I wanted.. But if I look at the previous records which display the text box I dont see the Opportunity name. It displays the OpportunityID.

Is there any way to display the Opportunity name in the text box.

Thanx again
Ekta

 

[Fornatian]

Check the bound field for the two duplicate fields,make sure they are both set to Opportunity Name, otherwise send me an example: formatian@aol.com
Make reference to this post

 

[Rich]

Here's another cheat you can use