NotInList Event

[FoxStudent]

On the notinlist event occuring i open a form to add in a new record. However, I went the value of the combo box to be added to the new form as well. However, the value of the combo box appears to be null when addressed. Is there anyway I can get the value in the combo box?

thank u

 

[tlbroadbent]

Use the TEXT property rather than the VALUE property.

From Access HELP:

The (the VALUE property setting) may or may not be the same as the setting for the Text property of the control. The current setting for the Text property is what is displayed in the text box portion of the combo box; the Value property is set to the Text property setting only after this text is saved. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin