If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Issues with Combo Box & Control can't be edited...
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. |
#2
|
|||
|
|||
Issues with Combo Box & Control can't be edited...
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/acc...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. druzzer wrote: 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. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201004/1 |
Thread Tools | |
Display Modes | |
|
|