Initial value in a ComboBox

[FRANKYAL]

HI:

I add a combo box to my form. The combo box Control Source is an SQL statement.I would like the combo box to display a
Value even before I select anything on it. This Value is in the Record Source but I will be getting it from other table.

Thank You

 

[rgbean]

Frank,
I assume you mean that the RecordSouce is an SQL statement. Do you have anything in the ControlSource? (Perhaps an aliased field or a form property?) Is BoundTo = .T.? Which column of the SQL are you binding it to? (BoundColumn) Is the Style = 2 - DropDown List?

Rick

 

[jonscott8]

HOWTO: Set the Default Choice in a List Box or Combo Box

http://support.microsoft.com/support/kb/articles/Q140/3/21.asp

Jon Hawkins

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed