Re: control can't be edited it is bound to an unknown field
From: Gerald Stanley (gcstanley_at_dsl.pipex.com)
Date: 03/09/04
- Next message: Dan Artuso: "Re: Combo box as criteria"
- Previous message: Jim: "Combo box as criteria"
- In reply to: Sacred: "control can't be edited it is bound to an unknown field"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 9 Mar 2004 14:58:46 -0800
Access is telling you that it cannot find a field called
UserId in the form's RecordSource.
Hope That Helps
Gerald Stanley MCSD
>-----Original Message-----
>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
>.
>
- Next message: Dan Artuso: "Re: Combo box as criteria"
- Previous message: Jim: "Combo box as criteria"
- In reply to: Sacred: "control can't be edited it is bound to an unknown field"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
