editing entries in a table using textboxes and a listbox

[Andy Weinmann]

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

[Pieter Linden]

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?)

[Andy Weinmann]

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?)

[Pieter Linden]

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?

[Andy Weinmann]

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.