Adding records on existing table
I have Ms Access table with 4 fields. I build a form so that users can add or edit the table. But I need only last three field to be modified while the first field to remain on showing the data/value exists. Summary: When I click add new record button, I need the first field to populate the existing values.
code:
DoCmd.GoToRecord, , acNewRec
I will appreciate your help.
Frank
Re: Adding records on existing table
Sounds like Access VBA. Moved from ClassicVb.
Re: Adding records on existing table
Save the three textbox fields contents to three separate variables. Then upon the add new you can also set the three textboxes to the variable values to autopopulate the textboxes for the new record.