Printable View
trying to code a command button to do the following :
1. add a new record to the table the form is based off of
2. drop the new project number into the 3 or 4 other tables that use it
can anyone think of a decent way to accomplish this considering i only have a rudimentary knowledge of VB?
Brandon
For steps 1 & 2: Execute an Append query to add the new record. Or do it with the use of a recordset but more coding knowledge reqd.
Out of curiosity why can the user not add a new record on the form itself ?
Basicly there is a frmNew_Project form that lets you put in a number, name, leader, evaluator, and a few other pieces of key info. The other tables wont have info in them right away, and prolly wont for a month or two. So I want a button on the frmNew_Project form that simply puts matching numbers in all of the subsidary tables. That way they dont have to go into multiple forms and what not and search for numbers in other places.
At least... thats the plan.
The thing is, I figured it would be append queries, but I have had 0 luck calling a query in VBA. So a brief handout / handup on syntax for such a thing would be greatly appreciated.
Brandon
-=sometimes nothing can be a real cool hand=-
See if this helps at all....
http://www.visualbasicforum.com/show...?postid=417475
Let me know if you're none the wiser after reading this. It is quite similar to what you what to do.
It's another forum if nothing else.
Thanks for the help KnooKie, it gave me a starting point for what to look for. I ended up goin to my local Borders and just buying a book. Then I fixed it in like 20 min.
Anyway, you are still my hero.
Brandon