Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old February 17th, 2005, 10:29 PM
Jessica Jessica is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 9 Jessica User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 8 h 19 m 2 sec
Reputation Power: 0
Post creating a subform

hi ,

i have create a form with subform here.
it looks like this :

Emp Name : _______ ID no: _________
Age : ______
-------------------------------------------------
No. Product Cost Quantity
1. ______ _____ _______
2. ______ _____ _______
3. ______ _____ _______
and so on ...
-------------------------------------------------

The form inside the dotted area is the subform while emp name, ID and age is in the main form.
My purpose is let the user do not need to key in the name, ID and age for many times. There will be many information to be filled up in the subform.
So how am I going to do if i want to save the subform information together with the main form in a same record?
Anybody has any idea for this?
Thanks.

Reply With Quote
  #2  
Old February 18th, 2005, 05:27 PM
lwells lwells is offline
Contributing User
Dev Articles Novice (500 - 999 posts)
 
Join Date: Sep 2004
Posts: 632 lwells User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 21 h 59 m 38 sec
Reputation Power: 5
Typically you will link the two forms together using the unique ID from each form. In your subform, click on the properties Data tab and then use the wizard to link the subform to your main form using the Link Child, Link Master properties.

lwells

Reply With Quote
  #3  
Old February 20th, 2005, 09:03 PM
Jessica Jessica is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 9 Jessica User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 8 h 19 m 2 sec
Reputation Power: 0
i created the form but the main form and the subform save the keyin information to seperate record, that means the main form save as an individual record and the subform save as another individual record. Why would this happen? i want to save the form in only a record so that i can retrieve it in the same form later.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > creating a subform


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT