Unable to add new record on data entry page

[michelleb1]

Suddenly I am unable to add new records on my form. I tested it and added new records, made some layout changes and now I cannot add new records. The standard add new record button with the asterisk is now disabled. I don't think I made any significant changes. Even weirder I had a backup copy with the form in working condition and so I tried to copy it to my most recent database version and once I copied it over it wouldn't work. What is going on? I'm going nuts. Any information would be helpful. Thanks in advance!

Michelle B

 

[djam]

I take it that your recordsource is based on a query with more then two tables?? Did you take out specific fields in your query recordsource?? Try opening the recordsource as a query and see if you can add records to it. If you can't then you are missing required fields for the recordsource.
" ahhh computers, how they made our lives much simpler "

 

[ahmun]

Here's a question for djam...

is it possible to create dataentry form based on a query that has more than two tables?

I would like to know how to do this... Earnie Eng
If you are born once, you will die twice.
If you are born twice, you will die once

 

[djam]

yes, but it is always best to have a form as one table and a subform as the other table whenever possible when dealing with a recordsource with multiple tables. So look at your design and see if you can break it up into subforms...

but there are obviously situations when you can't break it up and have to have multiple tables.

Here are some of the things to make sure you do:
1) include all primary key fields
2) include all foreign key fields
3) relationships are correct
4) include all required fields
5) when entering test data make sure that the foreign key
fields match the primary key fields in the relationship

You should first create the query which you are going to use as a record source with only the items that I listed above (don't include unnecessary fields) so that you can test if the query will allow you to perform a insert. When you perform your test, do it in datasheet view. When you have the insert working then add in all the other fields and then use it as a recordsource.

if your using linked tables let me know bc you may run into more problems " ahhh computers, how they made our lives much simpler "