Wrox Programmer Forums
|
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 April 16th, 2008, 02:29 PM
sms sms is offline
Authorized User
 
Join Date: Apr 2008
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default populating datasheet

Hi friends,
I am new to Ms Access and I am having problem of populating a datasheet form related to some field. That is I have a form that contains a field say (someID) and on the next form, it contains a subform with datasheet view. Now I have to populate the datasheet that is related to (someID) only.
Please do help me.


 
Old April 17th, 2008, 10:07 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You need to set the Master Child properties of the Sub Form.

Right click on your subform and select Properties. On the Data Tab, click in Link Master Field, and then follow the prompts.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old April 18th, 2008, 01:17 AM
sms sms is offline
Authorized User
 
Join Date: Apr 2008
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Friend it works.
But I am still getting a problem.
The problem is that each time the form containing the datasheet (subform) is opened, the datasheet subform loads all the records in the database. What I need is to load a datasheet that contain no previous records.
Please help me.
 
Old April 18th, 2008, 06:23 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I don't unerstand how this could be working and yet displaying "all" the records in the database. If the subform records are limited to the main form primary key, then the subform will only display those records related to the main form, and not "all" the records in the database. Can you explain the issue further?



mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old April 18th, 2008, 06:48 AM
sms sms is offline
Authorized User
 
Join Date: Apr 2008
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Actually what I mean is that I want to design a form containing datasheet as subform, which I wish it to insert new data.
Each time the form is loaded, datasheet displays all the records of previously entered data.
Each time the form is loaded, I want an empty datasheet to enter new records.

Thanks,





Similar Threads
Thread Thread Starter Forum Replies Last Post
problem in populating datasheet ...... sms Access 4 June 1st, 2008 03:47 AM
How to populate datasheet? sms Access 0 April 30th, 2008 11:45 PM
Subform Datasheet sadermine Access 2 August 8th, 2005 06:17 PM
Datasheet ColumnOrder vemaju Access 1 December 9th, 2004 09:04 AM





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