New record

[Tinky]

Hi
so my first request is about new record enabling. you know that little yellow star that exists at the bottom of a form or a table...
on the main form i have a few sub forms. some have that feature enabled and some don't.
how for god's sake can i control that yellow star? what is it's enabling regularity?

thanks for any help!!

 

[David R]

It depends on whether the query behind the form is updateable or not (assuming you haven't manually fiddled the Form Properties to Add New: NO, of course).

 

[Tinky]

hi
thanks for your quick reply
can you please direct me? where is that 'Add new' propety?
'cause I looked and looked for it and nothing...

 

[CJ_London]

In your form, open the properties for the form. On the data tab you will see Allow Additions. That is the Add New that David was referring to. To remove the yellow star change this to No.

If your recordsource for the form is or contains a cross tab, calculated fields, is a group By, etc it will not be updateable (so it doesn't matter if Allow Additions is true or not).

If you need it to be updateable there are some things you can try:

• Try changing the Recordset Type (same tab as above) to DynaSet (Inconsistent Updates)
• Use SELECT DISTINCT rather than GROUP BY - you many need to change the way some of the queries are constructed if you are using sum, count etc.
• Move calculated fields out of the recordsource and include them in unbound controls on your form instead
• If you have a crosstab query, save it as a table first and use the table in your query

 

[Tinky]

Hi
thanks
I see that the form as is has a "yes" in the "allow additions"
but if it's used as a subform in another screen, it doesn't have this propety in the properties list.
it's avery simple form, not a crosstab query
thanks for the help