"Tentative Append Record"

[starente15]

Hi,
My problem is that I am trying to build a form to do the data entry in and while the book says that I should be provided with a "tentative append record" meaning that an asterisk is visible allowing me to add entries to the form, that feature is turned off for some reason. Any ideas?

 

[braindead2]

as long as your form is bound to an updatable recordset then it should work

 

[starente15]

I'm not sure I understand what bound means. I've check the properties of the form and everything looks ok as far as allowing edits, deletions, additions and data entry being set to "yes." I can't find any obvious reason why it won't work.

 

[starente15]

Forgot to mention, I created a form from each individual table's fields and I can add data. When I create a form combining the fields of 5 tables, that's where I am running into a problem.

 

[gusbrunston]

Just a note:

You said you had "data entry" switched to "yes". I suppose you know that you can only add data with that form...no editing, etcetera. If you change it to "no", you can still add data as well as edit, etc.

Also, navigation buttons can be turned off in the properties sheet for the form...if they're off, turn 'em on. Gus Brunston An old PICKer, using Access2000
padregus@home.com

 

[petermeachem]

If the query for the form is based on 5 tables, then it is very likely that you can't add records. Look up 'updateable query' Peter Meachem
peter@accuflight.com