Access forms (reading table data)

[7Oclock]

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?

 

[mp9]

Is the form's Record Source property set?

 

[7Oclock]

Yes. The record source is set to the table.

 

[7Oclock]

Also if there are option buttons. How do they display? There is no record source in the design view.

 

[7Oclock]

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?

 

[randy700]

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


Randy