Help with Limit To List

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

Hello,
I have a field named CoursesLstID. With the following
properties set:
ColumnCount = 3
ColumnWidths = 0;4.9;0 (cm)
RowSourceType = Table/Query
RowSource = Select tblCoursesLst.CoursesLstID,
tblCoursesLst.CourseName, tblCoursesLst.CourseID From
tblCoursesLst Where tblCourseLst.CourseID = [Forms]!
[frmPersonnelInfo].[Form]![txtJobFunctionID]

BoundColumn = 1

This control displays all the Courses (CourseName)
depending on another field (JobFunction) this works fine.
But I also want to make this control "flexible". There are
courses recommended and requiered depending on the
person's job function but this doesn't mean that the user
can't fill in other courses(not listed). so I want the
Limit To List field to be No.

When I tried to do this, with BoundColumn = 1:
"Personnel Information Database can't set the Limit To
List property to No right now. The First visible column,
which is determined by the Column widths property, isn't
equal to the bound column. Adjust the ColumnWidths
property First and then set the LimitToList property"

If I change the BoundColumn value I get a type error
message..

any ideas?
 
on the field do a right click and select properties. Then
select the Data tab and then change the limit to list to
no.
 
Thank you es but I did that and it Access changes it
to "Yes" and shows the message I describe previously
-----Original Message-----
on the field do a right click and select properties. Then
select the Data tab and then change the limit to list to
no.

-----Original Message-----
Hello,
I have a field named CoursesLstID. With the following
properties set:
ColumnCount = 3
ColumnWidths = 0;4.9;0 (cm)
RowSourceType = Table/Query
RowSource = Select tblCoursesLst.CoursesLstID,
tblCoursesLst.CourseName, tblCoursesLst.CourseID From
tblCoursesLst Where tblCourseLst.CourseID = [Forms]!
[frmPersonnelInfo].[Form]![txtJobFunctionID]

BoundColumn = 1

This control displays all the Courses (CourseName)
depending on another field (JobFunction) this works fine.
But I also want to make this control "flexible". There are
courses recommended and requiered depending on the
person's job function but this doesn't mean that the user
can't fill in other courses(not listed). so I want the
Limit To List field to be No.

When I tried to do this, with BoundColumn = 1:
"Personnel Information Database can't set the Limit To
List property to No right now. The First visible column,
which is determined by the Column widths property, isn't
equal to the bound column. Adjust the ColumnWidths
property First and then set the LimitToList property"

If I change the BoundColumn value I get a type error
message..

any ideas?
.
Click to expand...
.
Click to expand...
 
Back
Top