Control can't be edited ???

[Dthmtlgod]

I have a simple list box. Using Access 2003

The listbox record source is set to Table/Query called Query1. The query is
very simple, Select RecordID, Name, Address, Job

Control Source is set to =[Query1].[RecordID]
Column Count is set to 4
Bound Column is set to 1

I am using a after_update event to open up another form based on the record
selected for editing.

I am getting the "control can't be edited" error.

Any assistance that can be provided is much appreciated.

 

[Guest]

I believe that your issue is that you are attempting to use an 'after update'
event for a box of which no update is possible....

Change that to maybe a focus change or exit or click or something....and see
if it works ok...

 

[Dthmtlgod]

Changed it to a onclick event. Same error.

I believe that your issue is that you are attempting to use an 'after
update'
event for a box of which no update is possible....

Change that to maybe a focus change or exit or click or something....and
see
if it works ok...

--
NTC

I have a simple list box. Using Access 2003

The listbox record source is set to Table/Query called Query1. The query
is
very simple, Select RecordID, Name, Address, Job

Control Source is set to =[Query1].[RecordID]
Column Count is set to 4
Bound Column is set to 1

I am using a after_update event to open up another form based on the
record
selected for editing.

I am getting the "control can't be edited" error.

Any assistance that can be provided is much appreciated.

 

[Guest]

yeah something isn't right....

I just threw up a test listbox on a test form....and used the after update
and click events ...and both worked to open another form...

I would do a sanity check. put another test list box on and set it up to
open a form...
--
NTC

Changed it to a onclick event. Same error.

I believe that your issue is that you are attempting to use an 'after
update'
event for a box of which no update is possible....

Change that to maybe a focus change or exit or click or something....and
see
if it works ok...

--
NTC

I have a simple list box. Using Access 2003

The listbox record source is set to Table/Query called Query1. The query
is
very simple, Select RecordID, Name, Address, Job

Control Source is set to =[Query1].[RecordID]
Column Count is set to 4
Bound Column is set to 1

I am using a after_update event to open up another form based on the
record
selected for editing.

I am getting the "control can't be edited" error.

Any assistance that can be provided is much appreciated.

 

[Dthmtlgod]

I have done that already. Plugged in an event with a hard coded value and
it work fine, it doesn't work when attempting to plug in a variable. I have
done a msgbox on the same event and that provides the correct RecordID.

So I think I need help with setting up "bounding" the form to control.

yeah something isn't right....

I just threw up a test listbox on a test form....and used the after update
and click events ...and both worked to open another form...

I would do a sanity check. put another test list box on and set it up to
open a form...
--
NTC

Changed it to a onclick event. Same error.

I believe that your issue is that you are attempting to use an 'after
update'
event for a box of which no update is possible....

Change that to maybe a focus change or exit or click or
something....and
see
if it works ok...

--
NTC


:

I have a simple list box. Using Access 2003

The listbox record source is set to Table/Query called Query1. The
query
is
very simple, Select RecordID, Name, Address, Job

Control Source is set to =[Query1].[RecordID]
Column Count is set to 4
Bound Column is set to 1

I am using a after_update event to open up another form based on the
record
selected for editing.

I am getting the "control can't be edited" error.

Any assistance that can be provided is much appreciated.

 

[Guest]

I misunderstood your problem. I thought your problem was that the 'event'
choosen related to the listbox, did not trigger the next event i.e. open a
form

I don't understand the 'plug in a variable' .....are you saying that the
next event is to be dependent upon the value of the list box selected?
--
NTC

I have done that already. Plugged in an event with a hard coded value and
it work fine, it doesn't work when attempting to plug in a variable. I have
done a msgbox on the same event and that provides the correct RecordID.

So I think I need help with setting up "bounding" the form to control.

yeah something isn't right....

I just threw up a test listbox on a test form....and used the after update
and click events ...and both worked to open another form...

I would do a sanity check. put another test list box on and set it up to
open a form...
--
NTC

Changed it to a onclick event. Same error.


I believe that your issue is that you are attempting to use an 'after
update'
event for a box of which no update is possible....

Change that to maybe a focus change or exit or click or
something....and
see
if it works ok...

--
NTC


:

I have a simple list box. Using Access 2003

The listbox record source is set to Table/Query called Query1. The
query
is
very simple, Select RecordID, Name, Address, Job

Control Source is set to =[Query1].[RecordID]
Column Count is set to 4
Bound Column is set to 1

I am using a after_update event to open up another form based on the
record
selected for editing.

I am getting the "control can't be edited" error.

Any assistance that can be provided is much appreciated.

 

[Dirk Goldgar]

I have a simple list box. Using Access 2003

The listbox record source is set to Table/Query called Query1. The
query is very simple, Select RecordID, Name, Address, Job

When you say "record source", do you mean "rowsource"? A list box
doesn't have a record source. Or are you talking about the recordsource
of the form containing the list box?

Control Source is set to =[Query1].[RecordID]
Column Count is set to 4
Bound Column is set to 1

I am using a after_update event to open up another form based on the
record selected for editing.

I am getting the "control can't be edited" error.

Any assistance that can be provided is much appreciated.

I think the problem is likely to be your setting for the list box's
Control Source. It sounds like this list box should be unbound, in
which case its Control Source should be left blank.