Can't edit form

[cubbyamber]

I have a form called contractors. It works exactly like I want it but it won't let me edit it. The form is based on a query. I have checked the query as stated to do on some areas of this forum and I am able to change it by typing something in a field and it also updates the form for me but I can't edit the form directly. I have allow edits, allow deletions, allow additions set to yes and I have no locks on it. Any ideas?

I have also checked help in access on this to no avail. I am attaching the database so somebody can hopefully help me.

Tracy

 

[cubbyamber]

Sorry, forgot to attach the database so here it is

Tracy

 

[Bodisathva]

you have the source of the text boxes set to specific columns in your drop down box, so modifying data in the text boxes is attempting to alter the data in the combo box, NOT your tables. Use the drop down box (you don't need all of the columns in the combo box, either) to select the specific record you want, and set the source of the text boxes to the fields in the recordset.

 

[cubbyamber]

Okay, I removed the control source for the text boxes but then I can't autopopulate the fields using the combo box. So how would I do that?

Trac

 

[Bodisathva]

A. In the On_Change event of the combo box, move the recordset to the selected item in combo box.

B. Also in the On_Change event of the combo box, place the extraneous column info from the combo box into the text boxes.

 

[cubbyamber]

I am very new to VB coding so please bear with me. What is the code that I would put in on change property?

Tracy

 

[cubbyamber]

Never mind I got it. Thank you from one pennsylvanian to another.

Tracy