Forms Not updated

[rahultiwari]

Hi.. I am trying to add data to the table. Is there any way that if i add data to the table the forms associated with it get updated automatically.
It seems that when I update the form it works fine with table ,but if its the other way around it doesnt work.
Any solutions..

Regards
Rahul

 

[RV]

Forms don't held data, they reflect data that is stored in your table(s).

Anyway, if your adding data directly to your tables and your form doesn't reflect the newly added data, well, then the way you use your form to reflect data is incorrect.

Your controls should be bound on your form and your form should be based on either a table or, the best way to go, on a query.

RV

 

[Pat Hartman]

Forms are based on recordsets which can be based directly on tables or on queries. They are not looking directly at a table under any conditions. So if you change something in the table, the form is still looking at the recordset made from that table, not at the table itself. To see changed to the table, the recordset needs to be requeried. Access will refresh the form's recordset at intervals but that only shows changes to existing records or marks records as being deleted. Refreshing the recordset does not show new records. Requerying the recordset will show new records as well as changes to existing records.