change date when append table

[Jimbo]

Hello group. I have searched high and low for this answer, including
searching these groups. I have a form that I update with a cmd button that
starts a append table query. I am refreshing my forms to show the update
too. I have just two fields; date and total. When I run my cmd the new
record is appended just fine, but the date is the current date. I would
like the date of the new record to be the value of a text box.

Any help would be appreciated.

Troy

 

[Roy Goldhammer]

Whell Jimbo

You should have textbox on your form and then you can add any date you want.

Then all you need is to bound the textbox to the field that have the date on
your table
Good luck

 

[Jimbo]

thanks, but when I do that all the records date changes. I only want to
change the new record.