pre-existing data does not populate form

[orioncurtis]

I created two tables and put data into them first thing. (Just a few enteries) Then i created a form for data entery which works for new data but will not show the data that was already in the table. How would i get the pre-existing data to populate the new form?

Thanks in advance.

 

[Rich]

Do you have the Data Entry set to yes on the Forms property sheet?

 

[orioncurtis]

set to no

Do you have the Data Entry set to yes on the Forms property sheet?

I have Data Entry set to no.
I just ended up deleting the entries in the tables and rentering them in through the form.
Do you have any other ideas why that would happen?


Thanks for you help.

 

[Pat Hartman]

If a form is not showing data that you KNOW is in the tables, it is because:
1. There is a filter on the form.
2. The form's recordsource query has criteria that is excluding the records.
3. The form's recordsource query has a join that is excluding the records.
4. The form's dataentry proproperty is set to Yes.

 

[hamzack]

Thank You!!

Thank you Pat Hartman. I had been having trouble displaying the record via form, and solved my dilemma by altering the join properties of the query the form was based on.