Go Back   Access World Forums > Microsoft Access Discussion > Forms

Thread Tools Rate Thread Display Modes
Old 04-13-2007, 05:42 AM   #1
Registered User
Join Date: Jan 2005
Location: Dorset
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
DavidRS is on a distinguished road
Displaying data on sub-form

I hope someone can help!

I've got a dbase that's used to record requests for government information. There are two key tables - one for requesters and the other for their requests. There can only be one requester but they may have more than one request. There are also 2 other tables for correspondence and restrictions (these are needed as there could be mulitple letters in & out and also there could be more than one restriction applied).

I've got a form that uses a query to ask for part of the name to then pull up the individual's data. There is a form for the requests which is opened from within the contact form. Whilst the request form loads OK, the subform won't show the data for the correspondence even though there is some information in there linked to the request ID. The same goes for the other forms.

I've linked them in the relationships so that it is a one to many link but i still can't see the data.


DavidRS is offline   Reply With Quote
Old 04-15-2007, 10:02 AM   #2
Newly Registered User
ezfriend's Avatar
Join Date: Nov 2006
Posts: 242
Thanks: 0
Thanked 0 Times in 0 Posts
ezfriend is on a distinguished road
It's hard to see what's exactly going wrong with the form; however, here are some suggestions:
-I am assuming that the records in your subform are bounded. Try to hardcode the filter and see if you get the data you want.
-Set your sub form data source to a query that will give you the data you need.

Hope that will help you troubleshoot the problem.

ezfriend is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 queries on Vista Steve Lang Windows 19 12-02-2009 09:23 AM
carrying data from one form to another mic907 Forms 4 11-29-2006 08:54 AM
Updating Data In Popup With View Form jaydwest SQL Server 0 11-26-2006 11:26 AM
Add a "Do Not Save" Option to a Data Entry Form with Multiple Subforms CarlyS General 1 12-07-2004 08:07 PM
Form and sub form order line data selecting MadRueNRG Forms 0 02-22-2004 04:35 PM

All times are GMT -8. The time now is 05:50 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World