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

Not able to add record

P: n/a
Hello,

My switchboard provides buttons to open several forms in Edit Mode. Some
forms allow adding a record while others do not. The forms that do not allow
additions are forms that contain a subform, plus they are populated through
a query. Otherwise the properties to allow edits, additions is set to yes.

Why would I not be able to add a record to these forms? Is it because
they're populated with a query?

Regards,

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


P: n/a
Cindi,

Your problem may be due to not using key fields to link tables inside
your queries. If you want to update or append records in a form bound to
a query, then a key field in one table should be linked to a key
field in the other table...otherwise you can't update these records.

Regards,
Mike

Cindi wrote:
Hello,

My switchboard provides buttons to open several forms in Edit Mode. Some
forms allow adding a record while others do not. The forms that do not allow
additions are forms that contain a subform, plus they are populated through
a query. Otherwise the properties to allow edits, additions is set to yes.

Why would I not be able to add a record to these forms? Is it because
they're populated with a query?

Regards,

Cindi

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.