Updating fields in a table from a form

[Damo10]

Hi,

I have a form which i would like to be able to update certain fields in a table, the table is called tblSealStrip and the fields to be updated are Seal1 & Seal2. The data will be coming from 2 text boxes called txtSeal1 & txtSeal2. The record in the table to be updated will have to match the WON field and there is a txtWON on the form with the number in

Could someone please tell me how to do this when the user press the Update button on the form.

Regards,

 

[sneuberg]

Make the table the Record Source for the form and then make the Control Source of txtSeal1 Seal1 and the Control Sources of txtSeal1 Seal2. The database fields will be update automatically whenever the form is closed or the current record is changed.

 

[Damo10]

Hi,

Thanks for the reply.

I tried before having the text boxes bound to the table but it was not working and I could only get it so that it was either changing the details in the first row in the table or adding a new row.

I have the data in the txtWON come from a query so does this make a difference as the user needs to select from a combobox which order they going to update?

Regards,

 

[sneuberg]

Sometimes it's hard to get a bound form to do what you want, but the alternative of doing the inserts, updates, and deletes in SQL becomes a maintenance nightmare. I think it's best to fight it out with the bound form.

I'm not seeing how this txtWON plays here. Could you upload what you got. It might help me see what you are trying to do.