Hi ,
I have a continuous form displaying records, with about five fields in each record. I was trying to write some VB code that would select the [account#] field in the current record, copy the value. go to the next record and paste the value in the same field. I don't want to create a new record, the next record is already there and has a blank Account# field.
My continuous form is actually a daily appointment schedule that that has an existing record for each time slot (every 15 minutes). I want to make a command button event that bascially copies the [account#] field value, goes to the next record (next time slot) and pastes the same account number in the [account#] field. This command button would be used to book for 30 minutes vs 15 minutes. You get the idea
It seems like it should be simple, but I haven't had any luck with the syntax??
Any thoughts
Thanks Chris
I have a continuous form displaying records, with about five fields in each record. I was trying to write some VB code that would select the [account#] field in the current record, copy the value. go to the next record and paste the value in the same field. I don't want to create a new record, the next record is already there and has a blank Account# field.
My continuous form is actually a daily appointment schedule that that has an existing record for each time slot (every 15 minutes). I want to make a command button event that bascially copies the [account#] field value, goes to the next record (next time slot) and pastes the same account number in the [account#] field. This command button would be used to book for 30 minutes vs 15 minutes. You get the idea
It seems like it should be simple, but I haven't had any luck with the syntax??
Any thoughts
Thanks Chris
