Combo Box row source issues

  • Thread starter Thread starter New_User
  • Start date Start date
N

New_User

I have a combo box in a subform. It displays five words in a drop down menu.
The combo box finds these words in another table. Up to this point the combo
box works correctly but when I finish adding the record on the subform and
move the focus on something else, it gives me an error message and I can't
continue.

The error message is...
Microsoft Office Access can't find the object 'SELECT [degree_type] FROM
[UserDegreeTypes] ORDER BY [degree_types],[degree_order];.'
If 'SELECT [degree_type] FROM [userDegreeTypes] ORDER BY
[degree_types],[degree_order];' is a new macro or macro group, make sure you
have saved it and that you have typed its name correctly.

But this is not a macro. I have a few other combo boxes and those work fine.
But I can't figure this one out.

Any help is greatly appreciated!
 
I would try going into the row source and change to --
'SELECT [degree_type] FROM [UserDegreeTypes] ORDER BY [degree_type];
 
I changed the row source to what you suggested in both the subform and the
table it is based on and now nothing shows up in the pull down. What else can
I try? And thank you for the help!

KARL DEWEY said:
I would try going into the row source and change to --
'SELECT [degree_type] FROM [UserDegreeTypes] ORDER BY [degree_type];

--
KARL DEWEY
Build a little - Test a little


New_User said:
I have a combo box in a subform. It displays five words in a drop down menu.
The combo box finds these words in another table. Up to this point the combo
box works correctly but when I finish adding the record on the subform and
move the focus on something else, it gives me an error message and I can't
continue.

The error message is...
Microsoft Office Access can't find the object 'SELECT [degree_type] FROM
[UserDegreeTypes] ORDER BY [degree_types],[degree_order];.'
If 'SELECT [degree_type] FROM [userDegreeTypes] ORDER BY
[degree_types],[degree_order];' is a new macro or macro group, make sure you
have saved it and that you have typed its name correctly.

But this is not a macro. I have a few other combo boxes and those work fine.
But I can't figure this one out.

Any help is greatly appreciated!
Click to expand...
Click to expand...
 
I changed the row source to what you suggested in both the subform and the
table it is based on and now nothing shows up in the pull down.

Just how did you change the row source in the table?
--
KARL DEWEY
Build a little - Test a little


New_User said:
I changed the row source to what you suggested in both the subform and the
table it is based on and now nothing shows up in the pull down. What else can
I try? And thank you for the help!

KARL DEWEY said:
I would try going into the row source and change to --
'SELECT [degree_type] FROM [UserDegreeTypes] ORDER BY [degree_type];

--
KARL DEWEY
Build a little - Test a little


New_User said:
I have a combo box in a subform. It displays five words in a drop down menu.
The combo box finds these words in another table. Up to this point the combo
box works correctly but when I finish adding the record on the subform and
move the focus on something else, it gives me an error message and I can't
continue.

The error message is...
Microsoft Office Access can't find the object 'SELECT [degree_type] FROM
[UserDegreeTypes] ORDER BY [degree_types],[degree_order];.'
If 'SELECT [degree_type] FROM [userDegreeTypes] ORDER BY
[degree_types],[degree_order];' is a new macro or macro group, make sure you
have saved it and that you have typed its name correctly.

But this is not a macro. I have a few other combo boxes and those work fine.
But I can't figure this one out.

Any help is greatly appreciated!
Click to expand...
Click to expand...
Click to expand...
 
I see a single quote in front of the SELECT that should not be there.
I guessed at the field name as you had [degree_types] and [degree_type].
Try using the SQL in a query to see if it returns records.
--
KARL DEWEY
Build a little - Test a little


New_User said:
I changed the row source to what you suggested in both the subform and the
table it is based on and now nothing shows up in the pull down. What else can
I try? And thank you for the help!

KARL DEWEY said:
I would try going into the row source and change to --
'SELECT [degree_type] FROM [UserDegreeTypes] ORDER BY [degree_type];

--
KARL DEWEY
Build a little - Test a little


New_User said:
I have a combo box in a subform. It displays five words in a drop down menu.
The combo box finds these words in another table. Up to this point the combo
box works correctly but when I finish adding the record on the subform and
move the focus on something else, it gives me an error message and I can't
continue.

The error message is...
Microsoft Office Access can't find the object 'SELECT [degree_type] FROM
[UserDegreeTypes] ORDER BY [degree_types],[degree_order];.'
If 'SELECT [degree_type] FROM [userDegreeTypes] ORDER BY
[degree_types],[degree_order];' is a new macro or macro group, make sure you
have saved it and that you have typed its name correctly.

But this is not a macro. I have a few other combo boxes and those work fine.
But I can't figure this one out.

Any help is greatly appreciated!
Click to expand...
Click to expand...
Click to expand...
 
I opened the form in design view, then I went to the field name that has the
combo box, clicked on look up on the bottom in field properties, in row
source I changed the statement to the one that you suggested. I did this
because I noticed that if I change the row source for the form, it won't
automatically change it in the table. I've tried changes the row source to
several different things and none of them worked , so I started changing both
table and form row sources to see if that made a difference.

KARL DEWEY said:
table it is based on and now nothing shows up in the pull down.

Just how did you change the row source in the table?
--
KARL DEWEY
Build a little - Test a little


New_User said:
I changed the row source to what you suggested in both the subform and the
table it is based on and now nothing shows up in the pull down. What else can
I try? And thank you for the help!

KARL DEWEY said:
I would try going into the row source and change to --
'SELECT [degree_type] FROM [UserDegreeTypes] ORDER BY [degree_type];

--
KARL DEWEY
Build a little - Test a little


:

I have a combo box in a subform. It displays five words in a drop down menu.
The combo box finds these words in another table. Up to this point the combo
box works correctly but when I finish adding the record on the subform and
move the focus on something else, it gives me an error message and I can't
continue.

The error message is...
Microsoft Office Access can't find the object 'SELECT [degree_type] FROM
[UserDegreeTypes] ORDER BY [degree_types],[degree_order];.'
If 'SELECT [degree_type] FROM [userDegreeTypes] ORDER BY
[degree_types],[degree_order];' is a new macro or macro group, make sure you
have saved it and that you have typed its name correctly.

But this is not a macro. I have a few other combo boxes and those work fine.
But I can't figure this one out.

Any help is greatly appreciated!
Click to expand...
Click to expand...
Click to expand...
 
You should change only the row source for the COMBO BOX.
--
KARL DEWEY
Build a little - Test a little


New_User said:
I opened the form in design view, then I went to the field name that has the
combo box, clicked on look up on the bottom in field properties, in row
source I changed the statement to the one that you suggested. I did this
because I noticed that if I change the row source for the form, it won't
automatically change it in the table. I've tried changes the row source to
several different things and none of them worked , so I started changing both
table and form row sources to see if that made a difference.

KARL DEWEY said:
I changed the row source to what you suggested in both the subform and the
Click to expand...
table it is based on and now nothing shows up in the pull down.

Just how did you change the row source in the table?
--
KARL DEWEY
Build a little - Test a little


New_User said:
I changed the row source to what you suggested in both the subform and the
table it is based on and now nothing shows up in the pull down. What else can
I try? And thank you for the help!

:

I would try going into the row source and change to --
'SELECT [degree_type] FROM [UserDegreeTypes] ORDER BY [degree_type];

--
KARL DEWEY
Build a little - Test a little


:

I have a combo box in a subform. It displays five words in a drop down menu.
The combo box finds these words in another table. Up to this point the combo
box works correctly but when I finish adding the record on the subform and
move the focus on something else, it gives me an error message and I can't
continue.

The error message is...
Microsoft Office Access can't find the object 'SELECT [degree_type] FROM
[UserDegreeTypes] ORDER BY [degree_types],[degree_order];.'
If 'SELECT [degree_type] FROM [userDegreeTypes] ORDER BY
[degree_types],[degree_order];' is a new macro or macro group, make sure you
have saved it and that you have typed its name correctly.

But this is not a macro. I have a few other combo boxes and those work fine.
But I can't figure this one out.

Any help is greatly appreciated!
Click to expand...
Click to expand...
Click to expand...
 
I had the SQL correct; without the quote.
Also, the SQL does return the results I want if I use it in a query but the
same SQL does not return results in the subform. What could the problem be?

KARL DEWEY said:
I see a single quote in front of the SELECT that should not be there.
I guessed at the field name as you had [degree_types] and [degree_type].
Try using the SQL in a query to see if it returns records.
--
KARL DEWEY
Build a little - Test a little


New_User said:
I changed the row source to what you suggested in both the subform and the
table it is based on and now nothing shows up in the pull down. What else can
I try? And thank you for the help!

KARL DEWEY said:
I would try going into the row source and change to --
'SELECT [degree_type] FROM [UserDegreeTypes] ORDER BY [degree_type];

--
KARL DEWEY
Build a little - Test a little


:

I have a combo box in a subform. It displays five words in a drop down menu.
The combo box finds these words in another table. Up to this point the combo
box works correctly but when I finish adding the record on the subform and
move the focus on something else, it gives me an error message and I can't
continue.

The error message is...
Microsoft Office Access can't find the object 'SELECT [degree_type] FROM
[UserDegreeTypes] ORDER BY [degree_types],[degree_order];.'
If 'SELECT [degree_type] FROM [userDegreeTypes] ORDER BY
[degree_types],[degree_order];' is a new macro or macro group, make sure you
have saved it and that you have typed its name correctly.

But this is not a macro. I have a few other combo boxes and those work fine.
But I can't figure this one out.

Any help is greatly appreciated!
Click to expand...
Click to expand...
Click to expand...
 
Just wanted to let you know that I solved the problem by creating a new table
and then a new subform from the new table. I used the SQL you gave me and now
its working fine.
Thanx for the help!

New_User said:
I had the SQL correct; without the quote.
Also, the SQL does return the results I want if I use it in a query but the
same SQL does not return results in the subform. What could the problem be?

KARL DEWEY said:
I see a single quote in front of the SELECT that should not be there.
I guessed at the field name as you had [degree_types] and [degree_type].
Try using the SQL in a query to see if it returns records.
--
KARL DEWEY
Build a little - Test a little


New_User said:
I changed the row source to what you suggested in both the subform and the
table it is based on and now nothing shows up in the pull down. What else can
I try? And thank you for the help!

:

I would try going into the row source and change to --
'SELECT [degree_type] FROM [UserDegreeTypes] ORDER BY [degree_type];

--
KARL DEWEY
Build a little - Test a little


:

I have a combo box in a subform. It displays five words in a drop down menu.
The combo box finds these words in another table. Up to this point the combo
box works correctly but when I finish adding the record on the subform and
move the focus on something else, it gives me an error message and I can't
continue.

The error message is...
Microsoft Office Access can't find the object 'SELECT [degree_type] FROM
[UserDegreeTypes] ORDER BY [degree_types],[degree_order];.'
If 'SELECT [degree_type] FROM [userDegreeTypes] ORDER BY
[degree_types],[degree_order];' is a new macro or macro group, make sure you
have saved it and that you have typed its name correctly.

But this is not a macro. I have a few other combo boxes and those work fine.
But I can't figure this one out.

Any help is greatly appreciated!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top