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

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Sacred (anonymous_at_discussions.microsoft.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 14:31:48 -0800

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

Relevant Pages

  • Re: control cant be edited it is bound to an unknown field
    ... UserId in the form's RecordSource. ... >from the query UserID is one of them. ... >turning Display Column Heads to Yes. ... >must be missing something. ...
    (microsoft.public.access.forms)
  • missing data from excel db query
    ... I am doing a query to an Excel spreadsheet. ... column is missing some data. ... It will display numbers but not text. ...
    (microsoft.public.frontpage.client)
  • Re: DB Result Wizard Error
    ... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)
  • RE: Just starting to design a form (or is it a query?)
    ... A Form is used to display the data and allow ... A query can be the record source for a form. ... that match an ID in the Assessment table. ... Now, assuming this is the case, what you need is a form with a sub form. ...
    (microsoft.public.access.gettingstarted)
  • Re: database lookup
    ... the query on the subsequent page, and display the "drill down" data. ... The thing with PHP and MySQL is that you need the user to do an action ... I tried to state that I have the database designed and implemented but I ...
    (alt.php)