How to overwrite existing record in the form in VBA?

[sallyGals]

i never learn vba before,but now my company need me to develop a system by using VBA. i wan to add in new record by overwrite/replace the existing record in da table...i create one command button called REFRESH ,then once user key in data and click on the REFRESH button,it will overwrite the existing record in the table....i do this because i wan to use this fom to create a report.
thx helping,any pointers?

 

[petrosky]

Hi sallGals,

If you don't need to retain the data...you could look into creating an unbound form with the necessary text box controls and pass the entered values to your report.

eg. On your report you could place your textbox controls, and in their control source property you could have =Forms!YourFormName!YourTextBoxName

Regards,

Peter.

Remember- It's nice to be important,
but it's important to be nice

 

[sallyGals]

hi peter

ok,i going to try now..
thx...