help with SELECT from current row and do an INSERT in a form

  • Ok, i haven't done Access or VBA in so long so here it goes. I've created a form in Tabular style. I want to be able to click on the row that i want to copy, click on Add Record comman button, and insert a row with some of the fields, not all. For example, there are 4 fields, EMPLID, NAME, AMOUNT, DESCRIPTION. I want to select from the first 3 fields and do an insert with the last field as blank. Help please.

  • nevermind. i tried deleting this post but it wont go away

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply