weird behavior for form ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been designing forms in access, but never encountered this before.

I created new form for data entry in Access with Sql server backend.
I created couple of records using this particular form/table.
When I open this form, I don't see the already existing records even though
it exists in the table. However, I am able to add new data thru' the form.

I would like to be able to view the existing data as well.
Where/what I should check? I already checked in form properties data tab,
allow filters, allow add, allow deletions, allow edits are all set to 'yes'.

Any ideas????

Thanks for your help in advance!
-Me
 
Sounds like the form's DATA ENTRY property is turned on. That allows you to
add/modify records up until you close the form. So, If you add ten records,
you will see those, but once you close the form and reopen it, you will see
no records.
 
Look down one more row in the Properties to the Data Entry property. If this
is set to Yes, you'll get what you're seeing.
 
Thank you Rick,
-Me

Rick B said:
Sounds like the form's DATA ENTRY property is turned on. That allows you to
add/modify records up until you close the form. So, If you add ten records,
you will see those, but once you close the form and reopen it, you will see
no records.
Click to expand...
 
Thank you Wayne,
-Me

Wayne Morgan said:
Look down one more row in the Properties to the Data Entry property. If this
is set to Yes, you'll get what you're seeing.
Click to expand...
 
Back
Top