Also Rain, staying up till 2am and taking the time to help me out - did not go unnoticed...just saying thank-you to you and Plog for all of your help doesn't seem enough, but it's all I can do You guys are great people
For some reason I can run through all my records on the form but can't seem to generate an empty form that users can then fill to populate the database
Plog
I was a bit worried that I would not be completely understood. In fact one of your statements led me to write something.
I did not catch onto where you were going with your multiple changes.
I simply used the Rule to be sure to be sure. I was trying also to avoid using someone's name in a critical manner. I am trying to be a good boy tonight. Talking of which it is 2:00 AM. I am off for now.
I'm not the best with forms, but my guess is you built a query and used that as the form's datasource. This is incorrect. Every form that will allow data manipulation (add/edit/delete) should be based on just one table. Sometimes, like this case, it will mean employing a sub-form.
You have 4 tables, that means 4 forms. Institutions, All Applicants (you should really remove the space from all table and field names), Awarded Grants and Fiscal Funding will have their own form. Fiscal Funding will be the unique one, it will have its own form, but that form will be a subform on the Awarded Grants form. That way you can add multiple years of funding to a grant.
You might be better off heading to the Forms section now and asking specific questions there.
So I ran a few queries and reports to make sure things were working, and everything seems to be working well. I created a form for users to be able to populate the database, but I'm having some difficulty with it - and could really use some help. For some reason I can run through all my records on the form but can't seem to generate an empty form that users can then fill to populate the database.
Maria,
Have you been playing with the properties on this Form.
Have a look at the option for Data Entry on the Data Tab. This should be set to No.
This is the opposite to what one would normally think.
It means that No the form is not set up for new Data Only. It will allow changes to old data and also add new data.
This may or may not be your solution. If not leave another question. Or you could do as plog says and open a new thread in the Forms area. But if you do please leave a note and a link here saying what you have done.