Access 2007 sub forms

[Shaun]

Hi all
I have converted an accress XP data file to access 2007. The problem I now
have is I cant add any data to the subforms. I have enabled all the allow
options but still no go! Please help this is quite urgent. My Email address
is shaunfish@gmail .com
Ta
Shaun Fisher

[Allen Browne]

Re: Access 2007 sub forms

Subforms do work in A2007, Shaun, so you have another problem to track down.
The people who volunteer their time here can make suggestions, but you
cannot email your database to them and expecet them to fix it for free.

If the subform is based on a query, you might open the query directly and
see if the new row exists there. If not, here's some reasons you might
check:
Why is my query read-only?
at:

http://allenbrowne.com/ser-61.html

If the query accepts a new row, but the subform does not, check the
properties of both the main form and subform. Make sure AllowEdits is Yes in
the main form, and AllowAdditions is Yes in the subform.

If the source query contains any function calls, or if the form/subform
contains any code, you may also need to check that your database is in a
trusted location:
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)

More info on adapting to A2007:

http://allenbrowne.com/Access2007.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Shaun" <shaunfish@gmai l.comwrote in message
news:1203742847 .441923@vasbyt. isdsl.net...

>
I have converted an accress XP data file to access 2007. The problem I now
have is I cant add any data to the subforms. I have enabled all the allow
options but still no go! Please help this is quite urgent. My Email
address is shaunfish@gmail .com
Ta
Shaun Fisher