Issues with Combo Box & Control can't be edited...

[druzzer]

Hi all,

I am really, really, really new to the world of Access, and have little to
no idea where to even begin.

I created a relatively simple database with equipment my company uses, and
supplemental accessories each item has. I would like to create a form or
page that my co-workers can call up, and use to search for a particular item
(by serial #), and see the associated accessories. I have that portion
worked out (I think), but when it comes time to attempt and edit the
accessories, I get the message:
"Control can't be edited, it's bound to the expression '[Tablet
#].column(1). I have a query set with the items from the table I would like
displayed, and have the accessories fields populated when the appropriate
serial # is selected from a combo box.

I guess what I need here is help so that when a serial # is selected, the
user can review the data, and then update the information. Please let me
know what data you need to diagnose the issue. I have no VBA experience, and
my Access experience is shakey at best, so please be gentle and dumb it down
as much as possible.

 

[BruceM via AccessMonster.com]

From what I can tell there should be a table of Equipment and a related
Accessories table. If an accessory is available to several pieces of
equipment you will need a third table (junction table) between the Equipment
and Accessories table.

In either case you would have a main form bound to the Equipment table and a
subform bound to either the Accessories table or the junction table. No
matter which situation you have, the combo box wizard should let you create
an unbound combo box for finding a record.

It sounds as if the text box in question is "looking" at a hidden column in
the combo box row source, but there really isn't enough to go on for me to
offer an informed suggestion. Please describe the table structure, and the
general idea of the interface.

As a new Access user you may benefit from reading some tutorials and so forth:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

IMO Crystal's tutorial is as good a starting place as any.

Hi all,

I am really, really, really new to the world of Access, and have little to
no idea where to even begin.

I created a relatively simple database with equipment my company uses, and
supplemental accessories each item has. I would like to create a form or
page that my co-workers can call up, and use to search for a particular item
(by serial #), and see the associated accessories. I have that portion
worked out (I think), but when it comes time to attempt and edit the
accessories, I get the message:
"Control can't be edited, it's bound to the expression '[Tablet
#].column(1). I have a query set with the items from the table I would like
displayed, and have the accessories fields populated when the appropriate
serial # is selected from a combo box.

I guess what I need here is help so that when a serial # is selected, the
user can review the data, and then update the information. Please let me
know what data you need to diagnose the issue. I have no VBA experience, and
my Access experience is shakey at best, so please be gentle and dumb it down
as much as possible.