Combo Box

[Guest]

I have a combo box with the Row Source: SELECT [Art].[ID],
[Art].[StyleNumber], [Art].[StyleDescription] FROM Art ORDER BY [StyleNumber];
Bound Column 1
Column Count 3
Column Widths 0",1",0"
Which is giving me the StyleNumber as I need it but then I have created an
unbound text box with the Control Source of =[cboArtID].[Column](2) to
display the StyleDescription in the field and it's giving me the ?#Name
error.

I had set this up earlier and it was working fine, and for some reason I
can't find my old post that helped me do this. I don't know what I did wrong
is there something someone else sees? or something that I should check?
Thanks so much

 

[Jeff Boyce]

Any chance that your PC has recently been "updated" to Access/Office 2003,
SP3? There are a host of bugs reported, and one of them involves
comboboxes.

The combobox-related issue is (apparently) resolved (i.e., worked-around) by
going back to the underlying table(s) and removing any display formatting
set on the table fields involved in the query/combobox.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thanks for the reply Jeff. No I'm working in Access 2007. I went back to my
table and removed any display formatting and it's still not working. I've
tried to create a new combo box and text box and that didn't work either. Is
there a relationship that I could be missing? I've created relationships
between the fields and tables that should be there. I'll double check
everything again. If you can think of anything else please let me know.
Thanks so much!
Eisa

Any chance that your PC has recently been "updated" to Access/Office 2003,
SP3? There are a host of bugs reported, and one of them involves
comboboxes.

The combobox-related issue is (apparently) resolved (i.e., worked-around) by
going back to the underlying table(s) and removing any display formatting
set on the table fields involved in the query/combobox.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a combo box with the Row Source: SELECT [Art].[ID],
[Art].[StyleNumber], [Art].[StyleDescription] FROM Art ORDER BY
[StyleNumber];
Bound Column 1
Column Count 3
Column Widths 0",1",0"
Which is giving me the StyleNumber as I need it but then I have created an
unbound text box with the Control Source of =[cboArtID].[Column](2) to
display the StyleDescription in the field and it's giving me the ?#Name
error.

I had set this up earlier and it was working fine, and for some reason I
can't find my old post that helped me do this. I don't know what I did
wrong
is there something someone else sees? or something that I should check?
Thanks so much

 

[Jeff Boyce]

Please post the SQL statement of the source of the combobox

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks for the reply Jeff. No I'm working in Access 2007. I went back to
my
table and removed any display formatting and it's still not working. I've
tried to create a new combo box and text box and that didn't work either.
Is
there a relationship that I could be missing? I've created relationships
between the fields and tables that should be there. I'll double check
everything again. If you can think of anything else please let me know.
Thanks so much!
Eisa

Any chance that your PC has recently been "updated" to Access/Office
2003,
SP3? There are a host of bugs reported, and one of them involves
comboboxes.

The combobox-related issue is (apparently) resolved (i.e., worked-around)
by
going back to the underlying table(s) and removing any display formatting
set on the table fields involved in the query/combobox.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a combo box with the Row Source: SELECT [Art].[ID],
[Art].[StyleNumber], [Art].[StyleDescription] FROM Art ORDER BY
[StyleNumber];
Bound Column 1
Column Count 3
Column Widths 0",1",0"
Which is giving me the StyleNumber as I need it but then I have created
an
unbound text box with the Control Source of =[cboArtID].[Column](2) to
display the StyleDescription in the field and it's giving me the ?#Name
error.

I had set this up earlier and it was working fine, and for some reason
I
can't find my old post that helped me do this. I don't know what I did
wrong
is there something someone else sees? or something that I should check?
Thanks so much

 

[Guest]

SELECT Art.ID, Art.StyleNumber, Art.StyleDescription
FROM Art
ORDER BY Art.[StyleNumber];

Please post the SQL statement of the source of the combobox

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks for the reply Jeff. No I'm working in Access 2007. I went back to
my
table and removed any display formatting and it's still not working. I've
tried to create a new combo box and text box and that didn't work either.
Is
there a relationship that I could be missing? I've created relationships
between the fields and tables that should be there. I'll double check
everything again. If you can think of anything else please let me know.
Thanks so much!
Eisa

Any chance that your PC has recently been "updated" to Access/Office
2003,
SP3? There are a host of bugs reported, and one of them involves
comboboxes.

The combobox-related issue is (apparently) resolved (i.e., worked-around)
by
going back to the underlying table(s) and removing any display formatting
set on the table fields involved in the query/combobox.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a combo box with the Row Source: SELECT [Art].[ID],
[Art].[StyleNumber], [Art].[StyleDescription] FROM Art ORDER BY
[StyleNumber];
Bound Column 1
Column Count 3
Column Widths 0",1",0"
Which is giving me the StyleNumber as I need it but then I have created
an
unbound text box with the Control Source of =[cboArtID].[Column](2) to
display the StyleDescription in the field and it's giving me the ?#Name
error.

I had set this up earlier and it was working fine, and for some reason
I
can't find my old post that helped me do this. I don't know what I did
wrong
is there something someone else sees? or something that I should check?
Thanks so much

 

[Jeff Boyce]

So the Control Source of your other control (the textbox) hasn't changed?
When Access shows "#Name" it means it can't find something the way it is
spelled.

Another approach would be to put some code in the AfterUpdate event of the
combobox, and use that to 'set' the value in the textbox. You could use
something like:

Me!YourTextBox = Me!YourCombobox.Column(2)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

SELECT Art.ID, Art.StyleNumber, Art.StyleDescription
FROM Art
ORDER BY Art.[StyleNumber];

Please post the SQL statement of the source of the combobox

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks for the reply Jeff. No I'm working in Access 2007. I went back
to
my
table and removed any display formatting and it's still not working.
I've
tried to create a new combo box and text box and that didn't work
either.
Is
there a relationship that I could be missing? I've created
relationships
between the fields and tables that should be there. I'll double check
everything again. If you can think of anything else please let me know.
Thanks so much!
Eisa

:

Any chance that your PC has recently been "updated" to Access/Office
2003,
SP3? There are a host of bugs reported, and one of them involves
comboboxes.

The combobox-related issue is (apparently) resolved (i.e.,
worked-around)
by
going back to the underlying table(s) and removing any display
formatting
set on the table fields involved in the query/combobox.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a combo box with the Row Source: SELECT [Art].[ID],
[Art].[StyleNumber], [Art].[StyleDescription] FROM Art ORDER BY
[StyleNumber];
Bound Column 1
Column Count 3
Column Widths 0",1",0"
Which is giving me the StyleNumber as I need it but then I have
created
an
unbound text box with the Control Source of =[cboArtID].[Column](2)
to
display the StyleDescription in the field and it's giving me the
?#Name
error.

I had set this up earlier and it was working fine, and for some
reason
I
can't find my old post that helped me do this. I don't know what I
did
wrong
is there something someone else sees? or something that I should
check?
Thanks so much

 

[Guest]

Thank Jeff, I got it. For some reason it didn't want the cbo in the code...it
works just as =ArtID.Column(2) interesting?
Thanks for your help!

So the Control Source of your other control (the textbox) hasn't changed?
When Access shows "#Name" it means it can't find something the way it is
spelled.

Another approach would be to put some code in the AfterUpdate event of the
combobox, and use that to 'set' the value in the textbox. You could use
something like:

Me!YourTextBox = Me!YourCombobox.Column(2)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

SELECT Art.ID, Art.StyleNumber, Art.StyleDescription
FROM Art
ORDER BY Art.[StyleNumber];

Please post the SQL statement of the source of the combobox

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks for the reply Jeff. No I'm working in Access 2007. I went back
to
my
table and removed any display formatting and it's still not working.
I've
tried to create a new combo box and text box and that didn't work
either.
Is
there a relationship that I could be missing? I've created
relationships
between the fields and tables that should be there. I'll double check
everything again. If you can think of anything else please let me know.
Thanks so much!
Eisa

:

Any chance that your PC has recently been "updated" to Access/Office
2003,
SP3? There are a host of bugs reported, and one of them involves
comboboxes.

The combobox-related issue is (apparently) resolved (i.e.,
worked-around)
by
going back to the underlying table(s) and removing any display
formatting
set on the table fields involved in the query/combobox.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a combo box with the Row Source: SELECT [Art].[ID],
[Art].[StyleNumber], [Art].[StyleDescription] FROM Art ORDER BY
[StyleNumber];
Bound Column 1
Column Count 3
Column Widths 0",1",0"
Which is giving me the StyleNumber as I need it but then I have
created
an
unbound text box with the Control Source of =[cboArtID].[Column](2)
to
display the StyleDescription in the field and it's giving me the
?#Name
error.

I had set this up earlier and it was working fine, and for some
reason
I
can't find my old post that helped me do this. I don't know what I
did
wrong
is there something someone else sees? or something that I should
check?
Thanks so much