control can't be edited it is bound to an unknown field

  • Thread starter Thread starter Sacred
  • Start date Start date
S

Sacred

Hi there,

I am doing a requery on a list box and I am getting the
above error in the title...

ACCESS 2002 ADP
SQL SERVER 2000 Back end

Basically this is how it goes. I have a combo box that
represents the user list for my website. I have a list
box that represents the users that are allowed to access
a particular area. Therefore the list box has to be
generated from a stored procedure that has 2 parameters
passed to it.

The VBA code looks looks like this..

Me!lst_Users.ControlSource = "UserID"
Me!lst_Users.RowSource = "EXEC
spGetResourceUserList " & lResourceID & "," & lLineID
Me!lst_Users.Requery

So the listbox will display the contents of the query
fine. However, it will not let me select and gives me
this error
"control can't be edited it is bound to an unknown field
UserID"

However, when I show all fields that are coming through
from the query UserID is one of them. How I check is by
turning Display Column Heads to Yes. Displaying all 3
columns with actual widths of 1" each. And when it gets
listed out the column Head is "UserID" and it does have a
row of numbers below it.

What Am I missing. To me this should be easy to do. I
must be missing something. I even have gone into the
query and cut and paste the field name from that area
into my code just to make sure I wasn't screwing up the
spelling. I have removed the EXEC at which point the
contents of the query will no longer display in the lsit
box. Still no luck.

Any Help would be appreciated.

Many Thanks,

Sacred
 
Access is telling you that it cannot find a field called
UserId in the form's RecordSource.

Hope That Helps
Gerald Stanley MCSD
 
Back
Top