Default Value field wont work?

[Guest]

I have a cbo (bound) with 4 selections to choose from. I would like the
default value to be set at one in the list. I have set the cbo propertys
default value to my selection [Pending] and also
[Forms]![fsubPipelineSumarry].[DefaultValue]="""pending""" but nothing works.
Any help would be greatly appreciated.

 

[Jeff Boyce]

What is the 'bound' field in the combobox? If it isn't the same field as
the one that hold "pending", it won't work that way.

What is the row source for your combobox?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

yes everything is the same. the cbo holds 4 selections and Pending is one of
them. It is the 3rd one down but I want it set to the default.

SELECT tlkFieldCodes.FieldCodeID, tlkFieldCodes.FieldCodeDesc FROM
tlkFieldCodes WHERE (((tlkFieldCodes.FieldCodeGroup)="Insurance
Consultants")) ORDER BY tlkFieldCodes.FieldCodeID;

What is the 'bound' field in the combobox? If it isn't the same field as
the one that hold "pending", it won't work that way.

What is the row source for your combobox?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a cbo (bound) with 4 selections to choose from. I would like the
default value to be set at one in the list. I have set the cbo propertys
default value to my selection [Pending] and also
[Forms]![fsubPipelineSumarry].[DefaultValue]="""pending""" but nothing
works.
Any help would be greatly appreciated.

 

[missinglinq via AccessMonster.com]

Get rid of your other attempts and try :

Private Sub Form_Current()
YourComboBox = "Pending"
End Sub

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Jeff Boyce]

If your first column is the ID (e.g., 3), and the first column is the
"bound" column, and the second column is the Description (e.g., "Pending"),
then you need to tell Access that the combobox's default value is 3.

Regards

Jeff Boyce
Microsoft Office/Access MVP

yes everything is the same. the cbo holds 4 selections and Pending is one
of
them. It is the 3rd one down but I want it set to the default.

SELECT tlkFieldCodes.FieldCodeID, tlkFieldCodes.FieldCodeDesc FROM
tlkFieldCodes WHERE (((tlkFieldCodes.FieldCodeGroup)="Insurance
Consultants")) ORDER BY tlkFieldCodes.FieldCodeID;

What is the 'bound' field in the combobox? If it isn't the same field as
the one that hold "pending", it won't work that way.

What is the row source for your combobox?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a cbo (bound) with 4 selections to choose from. I would like the
default value to be set at one in the list. I have set the cbo
propertys
default value to my selection [Pending] and also
[Forms]![fsubPipelineSumarry].[DefaultValue]="""pending""" but nothing
works.
Any help would be greatly appreciated.

 

[Guest]

Jeff I think your right. How would I go about doing this? Any help would be
appreciated.
Yes my ID is first and my selection is 2nd
Thanks again

If your first column is the ID (e.g., 3), and the first column is the
"bound" column, and the second column is the Description (e.g., "Pending"),
then you need to tell Access that the combobox's default value is 3.

Regards

Jeff Boyce
Microsoft Office/Access MVP

yes everything is the same. the cbo holds 4 selections and Pending is one
of
them. It is the 3rd one down but I want it set to the default.

SELECT tlkFieldCodes.FieldCodeID, tlkFieldCodes.FieldCodeDesc FROM
tlkFieldCodes WHERE (((tlkFieldCodes.FieldCodeGroup)="Insurance
Consultants")) ORDER BY tlkFieldCodes.FieldCodeID;

What is the 'bound' field in the combobox? If it isn't the same field as
the one that hold "pending", it won't work that way.

What is the row source for your combobox?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a cbo (bound) with 4 selections to choose from. I would like the
default value to be set at one in the list. I have set the cbo
propertys
default value to my selection [Pending] and also
[Forms]![fsubPipelineSumarry].[DefaultValue]="""pending""" but nothing
works.
Any help would be greatly appreciated.

 

[Jeff Boyce]

Take a look at the fields you are using as the row source in the combo box.

Now take a look at the values in the table that the query uses.

What is the ID value of the row that corresponds with the text value you
want to see?

Put that ID value in the combo box's Default value.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff I think your right. How would I go about doing this? Any help would
be
appreciated.
Yes my ID is first and my selection is 2nd
Thanks again

If your first column is the ID (e.g., 3), and the first column is the
"bound" column, and the second column is the Description (e.g.,
"Pending"),
then you need to tell Access that the combobox's default value is 3.

Regards

Jeff Boyce
Microsoft Office/Access MVP

yes everything is the same. the cbo holds 4 selections and Pending is
one
of
them. It is the 3rd one down but I want it set to the default.

SELECT tlkFieldCodes.FieldCodeID, tlkFieldCodes.FieldCodeDesc FROM
tlkFieldCodes WHERE (((tlkFieldCodes.FieldCodeGroup)="Insurance
Consultants")) ORDER BY tlkFieldCodes.FieldCodeID;

:

What is the 'bound' field in the combobox? If it isn't the same field
as
the one that hold "pending", it won't work that way.

What is the row source for your combobox?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a cbo (bound) with 4 selections to choose from. I would like
the
default value to be set at one in the list. I have set the cbo
propertys
default value to my selection [Pending] and also
[Forms]![fsubPipelineSumarry].[DefaultValue]="""pending""" but
nothing
works.
Any help would be greatly appreciated.

 

[Guest]

Jeff,

I know this should work but nothing. The value that goes with Pending is 9
but that does nto work also. I tried [9], =[9] etc and thing works. it comwes
up with null in the field.

Take a look at the fields you are using as the row source in the combo box.

Now take a look at the values in the table that the query uses.

What is the ID value of the row that corresponds with the text value you
want to see?

Put that ID value in the combo box's Default value.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff I think your right. How would I go about doing this? Any help would
be
appreciated.
Yes my ID is first and my selection is 2nd
Thanks again

If your first column is the ID (e.g., 3), and the first column is the
"bound" column, and the second column is the Description (e.g.,
"Pending"),
then you need to tell Access that the combobox's default value is 3.

Regards

Jeff Boyce
Microsoft Office/Access MVP

yes everything is the same. the cbo holds 4 selections and Pending is
one
of
them. It is the 3rd one down but I want it set to the default.

SELECT tlkFieldCodes.FieldCodeID, tlkFieldCodes.FieldCodeDesc FROM
tlkFieldCodes WHERE (((tlkFieldCodes.FieldCodeGroup)="Insurance
Consultants")) ORDER BY tlkFieldCodes.FieldCodeID;

:

What is the 'bound' field in the combobox? If it isn't the same field
as
the one that hold "pending", it won't work that way.

What is the row source for your combobox?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a cbo (bound) with 4 selections to choose from. I would like
the
default value to be set at one in the list. I have set the cbo
propertys
default value to my selection [Pending] and also
[Forms]![fsubPipelineSumarry].[DefaultValue]="""pending""" but
nothing
works.
Any help would be greatly appreciated.

 

[Jeff Boyce]

Using the square brackets tells Access that a Field named [whatever is
between the brackets] is to be used.

If you want the combobox default value to be 9 (?the integer value of the
row ID?), then put 9 in the Default Value property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,

I know this should work but nothing. The value that goes with Pending is 9
but that does nto work also. I tried [9], =[9] etc and thing works. it
comwes
up with null in the field.

Take a look at the fields you are using as the row source in the combo
box.

Now take a look at the values in the table that the query uses.

What is the ID value of the row that corresponds with the text value you
want to see?

Put that ID value in the combo box's Default value.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff I think your right. How would I go about doing this? Any help
would
be
appreciated.
Yes my ID is first and my selection is 2nd
Thanks again

:

If your first column is the ID (e.g., 3), and the first column is the
"bound" column, and the second column is the Description (e.g.,
"Pending"),
then you need to tell Access that the combobox's default value is 3.

Regards

Jeff Boyce
Microsoft Office/Access MVP

yes everything is the same. the cbo holds 4 selections and Pending
is
one
of
them. It is the 3rd one down but I want it set to the default.

SELECT tlkFieldCodes.FieldCodeID, tlkFieldCodes.FieldCodeDesc FROM
tlkFieldCodes WHERE (((tlkFieldCodes.FieldCodeGroup)="Insurance
Consultants")) ORDER BY tlkFieldCodes.FieldCodeID;

:

What is the 'bound' field in the combobox? If it isn't the same
field
as
the one that hold "pending", it won't work that way.

What is the row source for your combobox?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a cbo (bound) with 4 selections to choose from. I would
like
the
default value to be set at one in the list. I have set the cbo
propertys
default value to my selection [Pending] and also
[Forms]![fsubPipelineSumarry].[DefaultValue]="""pending""" but
nothing
works.
Any help would be greatly appreciated.

 

[Guest]

Yes I have done that. What I meant by stating I did [9] etc. I was trying to
say I have tried everything. Yes even the 9 does not work. A simple little
bound CBO is giving me more problems than a triple subform routine.

Using the square brackets tells Access that a Field named [whatever is
between the brackets] is to be used.

If you want the combobox default value to be 9 (?the integer value of the
row ID?), then put 9 in the Default Value property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,

I know this should work but nothing. The value that goes with Pending is 9
but that does nto work also. I tried [9], =[9] etc and thing works. it
comwes
up with null in the field.

Take a look at the fields you are using as the row source in the combo
box.

Now take a look at the values in the table that the query uses.

What is the ID value of the row that corresponds with the text value you
want to see?

Put that ID value in the combo box's Default value.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff I think your right. How would I go about doing this? Any help
would
be
appreciated.
Yes my ID is first and my selection is 2nd
Thanks again

:

If your first column is the ID (e.g., 3), and the first column is the
"bound" column, and the second column is the Description (e.g.,
"Pending"),
then you need to tell Access that the combobox's default value is 3.

Regards

Jeff Boyce
Microsoft Office/Access MVP

yes everything is the same. the cbo holds 4 selections and Pending
is
one
of
them. It is the 3rd one down but I want it set to the default.

SELECT tlkFieldCodes.FieldCodeID, tlkFieldCodes.FieldCodeDesc FROM
tlkFieldCodes WHERE (((tlkFieldCodes.FieldCodeGroup)="Insurance
Consultants")) ORDER BY tlkFieldCodes.FieldCodeID;

:

What is the 'bound' field in the combobox? If it isn't the same
field
as
the one that hold "pending", it won't work that way.

What is the row source for your combobox?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a cbo (bound) with 4 selections to choose from. I would
like
the
default value to be set at one in the list. I have set the cbo
propertys
default value to my selection [Pending] and also
[Forms]![fsubPipelineSumarry].[DefaultValue]="""pending""" but
nothing
works.
Any help would be greatly appreciated.

 

[Jeff Boyce]

So, when I've tried everything I know, and searched and tried what others
have offered, I usually delete the problem and start over. But that's just
me.

I don't have any other ideas, but maybe one of the other newsgroup readers
has run across this...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Yes I have done that. What I meant by stating I did [9] etc. I was trying
to
say I have tried everything. Yes even the 9 does not work. A simple little
bound CBO is giving me more problems than a triple subform routine.

Using the square brackets tells Access that a Field named [whatever is
between the brackets] is to be used.

If you want the combobox default value to be 9 (?the integer value of the
row ID?), then put 9 in the Default Value property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,

I know this should work but nothing. The value that goes with Pending
is 9
but that does nto work also. I tried [9], =[9] etc and thing works. it
comwes
up with null in the field.

:

Take a look at the fields you are using as the row source in the combo
box.

Now take a look at the values in the table that the query uses.

What is the ID value of the row that corresponds with the text value
you
want to see?

Put that ID value in the combo box's Default value.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff I think your right. How would I go about doing this? Any help
would
be
appreciated.
Yes my ID is first and my selection is 2nd
Thanks again

:

If your first column is the ID (e.g., 3), and the first column is
the
"bound" column, and the second column is the Description (e.g.,
"Pending"),
then you need to tell Access that the combobox's default value is
3.

Regards

Jeff Boyce
Microsoft Office/Access MVP

yes everything is the same. the cbo holds 4 selections and
Pending
is
one
of
them. It is the 3rd one down but I want it set to the default.

SELECT tlkFieldCodes.FieldCodeID, tlkFieldCodes.FieldCodeDesc
FROM
tlkFieldCodes WHERE (((tlkFieldCodes.FieldCodeGroup)="Insurance
Consultants")) ORDER BY tlkFieldCodes.FieldCodeID;

:

What is the 'bound' field in the combobox? If it isn't the same
field
as
the one that hold "pending", it won't work that way.

What is the row source for your combobox?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a cbo (bound) with 4 selections to choose from. I would
like
the
default value to be set at one in the list. I have set the cbo
propertys
default value to my selection [Pending] and also
[Forms]![fsubPipelineSumarry].[DefaultValue]="""pending""" but
nothing
works.
Any help would be greatly appreciated.