Subform not showing next record field

[Linda RQ]

Hi Everyone,

Access 2003. I am adding a new subform to a form. I has 2 fields for a
record, date and hours. The subform is on a tabbed form. My other subforms
that are exactly like this one (continuous forms) have data entered into
them and once data is entered, the next blank field appears so I can add a
new record. My new subform only has one field I can enter there is no new
fields. How do I fix this?

Thanks,
Linda

 

[ruralguy via AccessMonster.com]

Hi Linda,
Do you have Allow Additions set to Yes?

 

[Linda RQ]

Yes, it is. Any other ideas?

Hi Linda,
Do you have Allow Additions set to Yes?

 

[Linda RQ]

It is set to yes but no new record field

Hi Linda

Open the subform in design view and set the allow additions to = Yes

 

[Linda RQ]

More Info..

My subform is based on a query. When I click on the subform/subreport
properties I have in the Link Child and Master fields strEmployeeID. In the
subform field linker window the result says...Show qryExtraHours for each
record in qryDepartmentEmployees using strEmployeeID.

I am not sure if that has anything to do with anything but it won't hurt.
The other thing I notice is that the vertical scroll bar is not visable on
my form even though I have that to show only verticle scroll bar.

Thanks,
Linda

 

[ruralguy via AccessMonster.com]

Do you have a Join in the qryExtraHours query or is it just a limited query
of a table? If there is a Join, would it work if the Join were not there?
Does the verticle scroll bar *ever* show on the SubForm?

 

[Linda RQ]

I didn't have a join in the query but when I made the table, I did join it
in the relationships window. I deleted that relationship because the other
subforms that are based on queries that are working aren't joined. It
didn't change anything. It's still not giving me the option to add another
record. Here is the sql from the query, maybe that will help.

SELECT tblExtraHours.dttDateExtraHours, tblExtraHours.intExtraHours,
tblExtraHours.strEmployeeID
FROM tblExtraHours
GROUP BY tblExtraHours.dttDateExtraHours, tblExtraHours.intExtraHours,
tblExtraHours.strEmployeeID
HAVING (((tblExtraHours.dttDateExtraHours)>=DateAdd("d",-84,Date())))
ORDER BY tblExtraHours.dttDateExtraHours, tblExtraHours.intExtraHours DESC;

Hmm Verticle scroll bar...maybe it's not called a subform when it's on my
main form? I have a subform and when I just open that, there is no scroll
bar but when I used the little toolbox and inserted this subform/subreport
on my data entry form
there are scroll bars and record selectors. I don't show the record
selectors or the horizonal scroll bar. So what is a subform on a form
actually called?

Thanks,
Linda

 

[John Vinson]

SELECT tblExtraHours.dttDateExtraHours, tblExtraHours.intExtraHours,
tblExtraHours.strEmployeeID
FROM tblExtraHours
GROUP BY tblExtraHours.dttDateExtraHours, tblExtraHours.intExtraHours,
tblExtraHours.strEmployeeID
HAVING (((tblExtraHours.dttDateExtraHours)>=DateAdd("d",-84,Date())))

No GROUP BY query is EVER updateable. You can't add a new record to
this table because it's a Totals query.

Since you're not actually using any totals operations, open the query
in design view and unselect the Greek Sigma totals icon (looks like a
sideways M).

John W. Vinson[MVP]

 

[ruralguy via AccessMonster.com]

Hi Linda,
Forms are displayed on other forms by means of a SubForm Control. The
SubForm Control has properties of its own such as LinkChild/MasterField. The
scroll bars are *not* a SubForm Control property. They are a property of the
form that is being displayed by the SubForm Control. There, that should be
as clear as mud!

It looks like John Vinson has identified the update problem with the subform.

 

[Linda RQ]

That was it! Thankyou!!!! I also really appreciate you remembering or
figuring out by the language in my question that I really need a consice
simple explaination..."sidways M" <g> I didn't realize showing the totals
row would change the query.

Thanks a million again!

Linda

 

[Linda RQ]

Thank-you....Now you are as good as John at explaining things to me. <g>

Now that I don't have my totals row showing on my query, the scroll bar and
next record field are visable.

Linda

 

[John Vinson]

That was it! Thankyou!!!!

You're most welcome. Glad to be able to help!

I also really appreciate you remembering or
figuring out by the language in my question that I really need a consice
simple explaination..."sidways M" <g>

I've long since realized that a knowledge of the Greek alphabet is not

I didn't realize showing the totals
row would change the query.

It changes the query *into* a Totals query - that's the very function
of the button.

John W. Vinson[MVP]

 

[ruralguy via AccessMonster.com]

Thanks for posting back with your success Linda. Great news!

Thank-you....Now you are as good as John at explaining things to me. <g>

Now that I don't have my totals row showing on my query, the scroll bar and
next record field are visable.

Linda

Hi Linda,
Forms are displayed on other forms by means of a SubForm Control. The

[quoted text clipped - 42 lines]