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 15th, 2005, 01:56 PM
smurray smurray is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 13 smurray User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 9 m 25 sec
Reputation Power: 0
Question Auto-Populate Continuous Subform in Access 2000

Hello! I have two questions: I have a form that I created in Access 2000 that contains a subform with multiple pages that are linked to a main table. One of the pages in the subform is set up to be continuous. The subform has first name, last name and middle name text boxes that I would like to auto-populate if the user has more than one record to enter. For example, a user enters a new identification number and then clicks on the Defendent tab, then they enter the defendant's first and last name and middle initial and then enters a charge. If the defendant has multiple charges they can tab to the next entry in the subform...but is there a way that the first name, last name, and middle initial can be copied down so they don't have to re-type it?

Also, I mentioned above that a defendant can have multiple charges. So, under one identification number, there can be a bunch of continuous listings of different charges in the subform. Is there a way to have a field that would automatically assign a number to each of the charges? So if John Doe has 5 different charges, there would be five forms showing in the subform. The count field would assign numbers 1 through 5 to each of the charges...so instead of referring to the charge name, a user could refer to the number assigned to the charge. Is this possible? Please, let me know if I need to clarify anything further.

Thanks,
Shannon

Reply With Quote
  #2  
Old February 18th, 2005, 11:10 AM
smurray smurray is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 13 smurray User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 9 m 25 sec
Reputation Power: 0
Okay, I don't need help with the second part of my original post...however, I really would like to figure out how to do the first part. If anyone has any idea how to do this, please let me know...any help would be greatly appreciated. As I mentioned before I have a continuouse subform within a main form. And the user can enter many different charges for one person...instead of having to copy and paste (or retype) the first, last name, and middle initial on each subform entry, I was wondering if there is a way to enter the information once and get it to copy into the next form...so the user only needs to enter the next charge.

Thanks,
Shannon

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Auto-Populate Continuous Subform in Access 2000


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 4 hosted by Hostway