Subform only displaying one entry at a time

G

Guest

Hello. I have a subform containing a query which shows bookings made in a
given week. There are multiple bookings in a week but only ONE will be
displayed. Although the next booking can be viewed by clicked a 'next' button
on the form, I need all the bookings to be displayed in tablur form.
Any ideas what I am doing wrong?
Thanks.
 
G

Guest

Hi John,

Open your subform by itself in preview mode. It should open in datasheet or
continuous forms mode. You can verify this by opening the form in design
view. Click on View > Properties, if the properties dialog is not already
displayed. Make sure the name of the form is displayed in the blue title bar
of the properties dialog (you can click on the small black square in the
upper left corner of form design to select the form). Select the Format tab.
You will want the Default View to be either Datasheet or Continuous Forms.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hello. I have a subform containing a query which shows bookings made in a
given week. There are multiple bookings in a week but only ONE will be
displayed. Although the next booking can be viewed by clicked a 'next' button
on the form, I need all the bookings to be displayed in tablur form.
Any ideas what I am doing wrong?
Thanks.
 
G

Guest

Hi John,

Does the subform shown on the weekly bookings tab include entries in the
properties that read: Link Master Field and Link Child Field? If so, the
subform is likely being filtered by the primary key value of the record on
the main form.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Thanks for the reply. Unfortunatly that did not solve the problem. Here are
some screenshots of the possible areas of problem.

http://img.photobucket.com/albums/v241/Brigburn/1.jpg
http://img.photobucket.com/albums/v241/Brigburn/2.jpg
http://img.photobucket.com/albums/v241/Brigburn/props.jpg
__________________________________________

:

Hi John,

Open your subform by itself in preview mode. It should open in datasheet or
continuous forms mode. You can verify this by opening the form in design
view. Click on View > Properties, if the properties dialog is not already
displayed. Make sure the name of the form is displayed in the blue title bar
of the properties dialog (you can click on the small black square in the
upper left corner of form design to select the form). Select the Format tab.
You will want the Default View to be either Datasheet or Continuous Forms.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hello. I have a subform containing a query which shows bookings made in a
given week. There are multiple bookings in a week but only ONE will be
displayed. Although the next booking can be viewed by clicked a 'next' button
on the form, I need all the bookings to be displayed in tablur form.
Any ideas what I am doing wrong?
Thanks.
 
G

Guest

Thanks for the further advice. Unfortunatly though I cannot find Link Master
Field or Link Child Field in the properties (I have looked on everyone of the
things in the top drop down menu)
 
G

Guest

Ahh! sorry i have found it. I had to click on the window it was in. Completly
seperate to everything else. Both master and child have "Booking Number"
selected. Should this be removed / Changed ?
 
G

Guest

Hi John,

Try this article that I wrote. Althought it doesn't deal with the problem at
hand, Figure 5 shows an example of how to determine the name of the subform
container. The Link MF / Link CF is shown on the data tab:

http://www.access.qbuilt.com/html/subtotals.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Thanks for the further advice. Unfortunatly though I cannot find Link Master
Field or Link Child Field in the properties (I have looked on everyone of the
things in the top drop down menu)
 
G

Guest

Glad you found it!
Should this be removed / Changed ?
Click to expand...
I would think that it will need to be changed, not removed. If you remove
the Link MF / Link CF fields, then the subform will display ALL records, not
just records filtered for the current week.

I think you are going to need to use a query for this subform, which
includes a criteria that points to the main form to get the current week.
Does your main form include a date field?


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Ahh! sorry i have found it. I had to click on the window it was in. Completly
seperate to everything else. Both master and child have "Booking Number"
selected. Should this be removed / Changed ?
 
G

Guest

Sorry i suffered a powercut and i think it may of effected my previous reply!
I did find the properties containing "Find Master field" and "Find Child
Field". They both have 'Booking Number' Entered in. Should this be removed or
Edited?
 
G

Guest

It is already working off a query that filters the dates to the current week
(which works correctly independant of the subform - which just adds to my
confusion!)
 
G

Guest

If that's the case, then try removing the Link MF / Link CF values. If the
query returns the correct records by itself, then you don't want to apply any
additional filtering with Link MF / Link CF.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

It is already working off a query that filters the dates to the current week
(which works correctly independant of the subform - which just adds to my
confusion!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding new record 4
Spurious blank records being added 1
Autofill with a command button and prevent duplicate entries 4
Visble feild bassed on on other feilds 1
Links 2
Newbie needs help with a simple(?) query expression 11
Access ID 3
How to display rows that do not fall within 2 dates in a different 8

Top