By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,656 Members | 1,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,656 IT Pros & Developers. It's quick & easy.

Problem with Sub-Form and SQL-Server Back End

P: n/a
I'm working with an Access application which functioned as a split
database (front end, back end). The back end has recently been upgraded
to SQL-Server 2000, and all the minor bugs have been worked out, except
for one.

There is a form with 2 sub-forms which used to work as expected. Users
could add a record to the main form, and then add related records to
the two sub-forms. Now, however, the two sub-forms are blank, if the
subform 'Data Entry' value is set to 'Yes'. If the 'Allow Additions'
option is set to yes, exitising records display, but no new record is
displayed in the sub-form, so data entry can not occur.

Anu ideas? Other sub-forms in the application work just fine.

Thanks,

Tim Pascoe

Nov 15 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ti********@cciw.ca wrote:
I'm working with an Access application which functioned as a split
database (front end, back end). The back end has recently been upgraded
to SQL-Server 2000, and all the minor bugs have been worked out, except
for one.

There is a form with 2 sub-forms which used to work as expected. Users
could add a record to the main form, and then add related records to
the two sub-forms. Now, however, the two sub-forms are blank, if the
subform 'Data Entry' value is set to 'Yes'. If the 'Allow Additions'
option is set to yes, exitising records display, but no new record is
displayed in the sub-form, so data entry can not occur.

Anu ideas? Other sub-forms in the application work just fine.


Look to the recordsource of the subforms (the query/view/table), can you
enter new records in there?

On the ones with existing records, can you edit them?

Nov 15 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.