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

Editing values from a bounded object

P: 8
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
Jan 14 '08 #1
Share this Question
Share on Google+
7 Replies


Rabbit
Expert Mod 10K+
P: 12,357
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.
Jan 14 '08 #2

P: 8
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???
Jan 14 '08 #3

Rabbit
Expert Mod 10K+
P: 12,357
Check the control sources, they should be bound to field names from your table. Also, try closing all other forms, tables, and queries.
Jan 14 '08 #4

P: 8
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
Jan 14 '08 #5

Rabbit
Expert Mod 10K+
P: 12,357
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.
Jan 14 '08 #6

P: 8
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
Jan 14 '08 #7

Rabbit
Expert Mod 10K+
P: 12,357
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.
Jan 14 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.