I created a form but the navigation controls at the bottom don't display table data. How can I correct this. Also the 'datasheet view' is grayed out and not available. Why?
Another problem: If I want a form to display data from a table. The 'record source' needs to be the table but what if I want it to both display from the table and also be the entry for a new record for the table? The 'record source' can't be both the field in the table and just a field in the form. Or can it?
It is usually better practice to base your form on a query rather than the table directly. To display and update records, make sure the forms properties include:
Allow Additions = yes
Allow Edits = yes
Allow Deletions = yes ?? if you want this ability
Navigation Buttons = yes
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.