Prev: presence and absence
Next: Assign zero to null combo box
From: JamesJ on 24 Dec 2009 06:47
In a combo box based on a Table/Query how can I display
something like "Plase make a selection" as opposed to the
cbo being blank prior to making a selection?

Thanks,
James


From: Tom van Stiphout on 24 Dec 2009 08:53
On Thu, 24 Dec 2009 06:47:01 -0500, "JamesJ"
<jjy(a)darwin_roadrunne0r.com> wrote:

If you're doing Table/Query all the data has to come from a query. So
I create a new table (say tblMakeSelection) with one row in it:
-1, "Please make a selection"
and then I use a union query:
select CompanyID, CompanyName from tblCompanies
union
select ID, Description from tblMakeSelection

-Tom.
Microsoft Access MVP


>In a combo box based on a Table/Query how can I display
>something like "Plase make a selection" as opposed to the
>cbo being blank prior to making a selection?
>
>Thanks,
>James
>
>
From: JamesJ on 24 Dec 2009 11:39
Works ok.
Had to set the combo box's default value to -1 to get it to display
initially.

Thanks much,
James


"Tom van Stiphout" <tom7744.no.spam(a)cox.net> wrote in message
news:les6j5tlj4v6jg0g2n12mgibenb3q9um8a(a)4ax.com...
> On Thu, 24 Dec 2009 06:47:01 -0500, "JamesJ"
> <jjy(a)darwin_roadrunne0r.com> wrote:
>
> If you're doing Table/Query all the data has to come from a query. So
> I create a new table (say tblMakeSelection) with one row in it:
> -1, "Please make a selection"
> and then I use a union query:
> select CompanyID, CompanyName from tblCompanies
> union
> select ID, Description from tblMakeSelection
>
> -Tom.
> Microsoft Access MVP
>
>
>>In a combo box based on a Table/Query how can I display
>>something like "Plase make a selection" as opposed to the
>>cbo being blank prior to making a selection?
>>
>>Thanks,
>>James
>>
>>
 | 
Pages: 1
Prev: presence and absence
Next: Assign zero to null combo box