Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 3rd, 2004, 05:36 AM
Authorized User
 
Join Date: Feb 2004
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default Adding details from a form to another

hello every one
Help Please Please Please
i have a form and a subform
is it possible to add data in to subform from another form
what i mean is for example a in my subform i want to put a button(add details) and when i click on that it will open another form which will get data from another table and when i select record and click on the add button which is in this form it will put my selected record in to the subform or have a dropdown list when i choose a record it will add the choosen record in to the all fields


Best Regards,
Hamed Gholamian
 
Old September 3rd, 2004, 08:50 AM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

This may help you

http://support.microsoft.com/?kbid=208824

 
Old September 3rd, 2004, 09:45 AM
Authorized User
 
Join Date: Feb 2004
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

well i tried northwind but there were some parts which was a liitle complicated but again if you have something which can help i will really apperciate

Best Regards,
Hamed Gholamian
 
Old September 3rd, 2004, 10:51 AM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Was there any part in particular you did not understand?

If your sub-form uses the same source table/Query as the form you are adding your new record to,then all you will need to do is refresh your data after it is added to your form. Once the data is refresh it will be available in your sub-form or drop down list.

Additional to clarify

Is this what you what to do?
you want to use values of one form in to another form?

Forms!frm_Main!sub_Form_Main!txtName.value = strNewTXTName
 
Old September 4th, 2004, 07:21 AM
Authorized User
 
Join Date: Feb 2004
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Really thanks for your reply
Ok this is what i am looking for
---------------------------------Tables Section
table-> name
Fields
no
name
-------------------
table-> details
Fields
telno
home
add
----------------------------------Forms section
Main form (using table name)
No:
name:
date
subform (using table details)
telno:
home:
add:
[add details(as a button)]
----------------

Extra details form
same as subform
[ add the selected record to subform(as a button)]
-----------------

when you click on the add the seleceted... what i need to do is add the selected record to the subform



Best Regards,
Hamed Gholamian
 
Old September 20th, 2004, 09:00 AM
Authorized User
 
Join Date: Feb 2004
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

any body can help please

Best Regards,
Hamed Gholamian
 
Old September 21st, 2004, 01:15 PM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

U may have a form with a subform in a one-to-many relationship but i dont think
u could open the subform alone to enter data.U may open the form with the subform (the button is optional) and u may have lookup fields in the subform where u may choose a value as data entry.
Regards Penta.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding controls to a form Scootterp Access VBA 2 August 4th, 2009 02:32 PM
Retrievin form details and sending email yus_nash Beginning PHP 3 September 16th, 2004 04:48 AM
adding a control onto a form yun VS.NET 2002/2003 1 July 2nd, 2004 03:15 AM
Adding a record using a form cailos Access 2 October 12th, 2003 11:10 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.