Form Problem

[CosmaL]

Hello everybody!

I have a form and the problem is the following:

On my main form i have a button to open the form to add only data.

If i finish inserting data and close the form, when i try to open the form(with another button) and view all the records, i get again a new record form...

I've done a query to view the data and it's working.

Furthermore, i've created a form with query's results and i've also added a button to view the specific record data. ("ID=" & Me.[ID]). Again, i get a blank form to add new record... :banghead:

Finally i've tried to see what's going on by changing some form settings (like both scroll bars) and i get no result... The form looks like stack in adding only new records anytime

I use access 2010.

Any ideas?

Thanks in advance!

 

[pbaldy]

What is the data entry property of the form?

 

[CosmaL]

Data entry is set to yes, allow edits/additions/etc are also to yes...

 

[CosmaL]

I've also noticed, that on the forms filter-after running the query-i have ex: id=10.

Form gets filter but doesn't show record, it stil asks for new record...

 

[pbaldy]

That's what the data entry property is for. Change it to no.

 

[CosmaL]

It's working!!!!!!!!! Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[pbaldy]

Happy to help!