Editing values from a bounded object

[GabyFont]

Hi,
I'm new to Access so excuse if my question is too simple. I'm creating an app to manage spare objects in my company. So a user select from list boxes the criteria they want and hit a button that runs a query and display the results in a sub-form in the current view. The user look for the record he needs, and then double-click it. When the record is clicked, another form opens, in this form, there are bounded text boxes with the information of the selected item. In this view, I want the user to enter the new info for the item selected (plant, building, floor, DNS, IP and change it status from "Spare" to "Active") and then, using a button, save and exit the form.
The problem is that when I try to edit any field in the second form (after double-clicking the selected item), access don't leave me change anything (I think it is because is a bounded object, but not sure why and what to do)
Any Ideas???

using Access2007 in WinXp Professional
Thank you in advance

[Rabbit]

Please don't double post your questions, your other thread will be deleted.

Check the Allow Edits property of your form, it should be set to Yes.

[GabyFont]

Please don't double post your questions, your other thread will be deleted.

Check the Allow Edits property of your form, it should be set to Yes.

I'm sorry, I didn't remember sending it twice,
The property of the form is already set to "Edit" also each text box.
Any other idea???

[Rabbit]

Check the control sources, they should be bound to field names from your table. Also, try closing all other forms, tables, and queries.

[GabyFont]

Check the control sources, they should be bound to field names from your table. Also, try closing all other forms, tables, and queries.

All controll are bounded to the subform where the user makes it selection

[Rabbit]

All controll are bounded to the subform where the user makes it selection

Are you saying that the Second form is bound to the first form's subform? That doesn't work. You need to set the control source to same table and bind the fields that way.

[GabyFont]

ok, I get you, but how can I do that, since I'm trying to edit the record choosed (by double clicking on it) by the user, in the subform of my main form

[Rabbit]

ok, I get you, but how can I do that, since I'm trying to edit the record choosed (by double clicking on it) by the user, in the subform of my main form

When you run the DoCmd.OpenForm, use the WHERE parameter to restrict which record gets returned.