Hello, I was hoping someone could tell me a way to perform what may or may not be a simple problem:
I'd like to build a small form with one text box and one button (Add New Record) which will take the information in the text box and append it to a field in two different tables within the same database.
In this case, it's a Name field I want to be able to append to the Name field in my Master table, as well to another table, (in this case, 'Faculty') so that I'm in effect creating a new record.
Is there a VB code source for this? I've checked many examples on-line.
I'd like to build a small form with one text box and one button (Add New Record) which will take the information in the text box and append it to a field in two different tables within the same database.
In this case, it's a Name field I want to be able to append to the Name field in my Master table, as well to another table, (in this case, 'Faculty') so that I'm in effect creating a new record.
Is there a VB code source for this? I've checked many examples on-line.