By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,476 Members | 889 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,476 IT Pros & Developers. It's quick & easy.

Need help opening one form from another (was VB Code)

P: 2
hello Guys

I am a new programmer, and could some one hlep me here

I created a data base, and from the Form view, were i input infromation to my Data base, i need to create a button, that will on clicking it, pop-up a table and allow the user to insert information into that table and save on finish, and this will happen after every time when a new record is inserted
Aug 9 '07 #1
Share this Question
Share on Google+
2 Replies


P: 5
hello Guys

I am a new programmer, and could some one hlep me here

I created a data base, and from the Form view, were i input infromation to my Data base, i need to create a button, that will on clicking it, pop-up a table and allow the user to insert information into that table and save on finish, and this will happen after every time when a new record is inserted
Hi busego,

To do this you'll have to put code into the 'On Click' event for your button (this can be accessed from the property sheet). The command you're needing in VBA is DoCmd.OpenTable. You can get help on how this command works and what it's syntax is by searching on "OpenTable Method" from within VBA (which you can reach from Tools->Macro->Visual Basic Editor). I think the actual command you'll use is this:
DoCmd.OpenTable "TableName", , acAdd

HTH

Brian
Aug 9 '07 #2

missinglinq
Expert 2.5K+
P: 3,532
Please remember to provide a meaningful Title for any threads you start! This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions. It is difficult for the experts to answer questions when there is not enough details provided to understand the problem.

Please take the time to read the Posting Guidelines, paying particular attention to Give a clear title to your question.

http://www.thescripts.com/forum/thread559246.html


Thank you and Welcome to TheScripts!!

Linq ;0)>
Aug 9 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.