Add another Combo Box Question!

[Bob V]

On my Form I have a Unbound Combo Box[cbHorseName] ( Which has HorseName &
HorseID) which comes from tblHorseInfo
I want to add another combo box to my from which is a field in tblHorseInfo
called [Covers]
How can I get my new combo box to show what is in [Covers] with the same
HorseID?
HorseID being the AutoNumber

 

[Beetle]

If [Covers] is another field in the same table, then you don't need to add
another combo box. You can just add another column to your existing combo
box.

Open your form in design view, go to the properties sheet for your combo
box. Under the Data tab go to the Row Source line. Click the elipse to the
right to open the query. Add the [Covers] field to the query and close it.
You will also need to make sure that the Column Count and Column Width
properties are set correctly so the [Covers] field will show up in your combo
box (these properties are in the Format tab of the properties sheet)

HTH

 

[Bob V]

Thanks Beetle and sorry I forgot to ask for help
Just one small problem I wanted it in another place on my form not next to
his name
Thanks for your help Bob

If [Covers] is another field in the same table, then you don't need to add
another combo box. You can just add another column to your existing combo
box.

Open your form in design view, go to the properties sheet for your combo
box. Under the Data tab go to the Row Source line. Click the elipse to the
right to open the query. Add the [Covers] field to the query and close it.
You will also need to make sure that the Column Count and Column Width
properties are set correctly so the [Covers] field will show up in your
combo
box (these properties are in the Format tab of the properties sheet)

HTH
--
_________

Sean Bailey

On my Form I have a Unbound Combo Box[cbHorseName] ( Which has HorseName
&
HorseID) which comes from tblHorseInfo
I want to add another combo box to my from which is a field in
tblHorseInfo
called [Covers]
How can I get my new combo box to show what is in [Covers] with the same
HorseID?
HorseID being the AutoNumber

 

[Bob V]

The other thing is the query it is using is one of those queries that has
nothing in Data View sheet, regards Bob
SELECT tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,False) AS
Name
FROM tblHorseInfo
WHERE (((tblHorseInfo.HorseID)=[Forms]![frmInvoice]![cbHorseName]));

Thanks Beetle and sorry I forgot to ask for help
Just one small problem I wanted it in another place on my form not next to
his name
Thanks for your help Bob

If [Covers] is another field in the same table, then you don't need to
add
another combo box. You can just add another column to your existing combo
box.

Open your form in design view, go to the properties sheet for your combo
box. Under the Data tab go to the Row Source line. Click the elipse to
the
right to open the query. Add the [Covers] field to the query and close
it.
You will also need to make sure that the Column Count and Column Width
properties are set correctly so the [Covers] field will show up in your
combo
box (these properties are in the Format tab of the properties sheet)

HTH
--
_________

Sean Bailey

On my Form I have a Unbound Combo Box[cbHorseName] ( Which has HorseName
&
HorseID) which comes from tblHorseInfo
I want to add another combo box to my from which is a field in
tblHorseInfo
called [Covers]
How can I get my new combo box to show what is in [Covers] with the same
HorseID?
HorseID being the AutoNumber