By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,935 Members | 1,528 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,935 IT Pros & Developers. It's quick & easy.

editing entries in a table using textboxes and a listbox

P: n/a
I need to make a form through which I can edit the information for
companies. I used a form in which the textboxes read from different
columns from a listbox to display the information for a company, but
it tells me the form is read-only, even when i set the "locked"
property for all of my textboxes to "no". What do I do? Is it
because the textboxes are reading from the listbox rather than the
table? If so, what code do I use to make the textboxes from the table
where the ID equals that of the company selected in the listbox?

TIA,
Andy
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
ar********@student.ysu.edu (Andy Weinmann) wrote in message news:<b7**************************@posting.google. com>...
I need to make a form through which I can edit the information for
companies. I used a form in which the textboxes read from different
columns from a listbox to display the information for a company, but
it tells me the form is read-only, even when i set the "locked"
property for all of my textboxes to "no". What do I do? Is it
because the textboxes are reading from the listbox rather than the
table? If so, what code do I use to make the textboxes from the table
where the ID equals that of the company selected in the listbox?

TIA,
Andy


1. base your form on the Companies table.
2. put a combobox on the form and when the wizard prompts, choose "Go
to record..." or whatever to move to the record selected in the
combobox. Listboxes are great, but not really ideal for this process.
Besides, you don't need to select more than one value at a time...
(Or do you?)
Nov 13 '05 #2

P: n/a
I select a work category in a combo box, and then the listbox displays
the companies that fall into that work category. Would I be better
off putting the companies into a combobox then? If so, how do i go
about editing the information for the selected company?

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...
ar********@student.ysu.edu (Andy Weinmann) wrote in message news:<b7**************************@posting.google. com>...
I need to make a form through which I can edit the information for
companies. I used a form in which the textboxes read from different
columns from a listbox to display the information for a company, but
it tells me the form is read-only, even when i set the "locked"
property for all of my textboxes to "no". What do I do? Is it
because the textboxes are reading from the listbox rather than the
table? If so, what code do I use to make the textboxes from the table
where the ID equals that of the company selected in the listbox?

TIA,
Andy


1. base your form on the Companies table.
2. put a combobox on the form and when the wizard prompts, choose "Go
to record..." or whatever to move to the record selected in the
combobox. Listboxes are great, but not really ideal for this process.
Besides, you don't need to select more than one value at a time...
(Or do you?)

Nov 13 '05 #3

P: n/a
ar********@student.ysu.edu (Andy Weinmann) wrote in message news:<b7**************************@posting.google. com>...
I select a work category in a combo box, and then the listbox displays
the companies that fall into that work category. Would I be better
off putting the companies into a combobox then? If so, how do i go
about editing the information for the selected company?


If you are already in a form based on the Company table, you should be
able to edit the records. is the form based on a query that makes the
recordset not updateable? (Like a summary query?) You haven't set the
form to be read-only or something like that, have you?
Nov 13 '05 #4

P: n/a
I'm not sure, that's my problem. I'm quite new to Access, and I
therefore am not sure of the best way to go about editing data in a
table through a form. I just know that for the person using the
database to be able to find the record they are looking for out of the
600 some in the table, they need to be able to sort them out by work
category, and then find them. Any advice you can giveme would be
greatly appreciated.
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.