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

[busego]

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

[hellsgate]

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

[missinglinq]

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)>