Edit Previous Entries Using Form - Odd...

[kevygee]

I'm working on a pre-existing form. When I open the form, I am able to enter new data and this data gets stored in the database fine. If I close that form and reopen it, I cannot view past entries or edit them. I know of a property (Allow Additions, Allow Edits, Allow Delete) which can change this behaviour, but these seem to do nothing for this form. I have them all set on yes and it behaves as I've described. Ideally, I would like to allow edits of previous data.

I thought maybe the SQL query controlling the data wasn't returning any entries, therefore no entries would be displayed. So I saved the query and opened it up to see how many entries it did find. And it found all that it should have, so I know that the SQL statement controlling the form is what I want it to be.

So my question is this: are there anymore properties or values that I don't know about, that would control the mentioned behaviour of the form? Maybe something somewhere that I'm missing, that would make the form add only?

Thanks in advance for any help. Kevygee

 

[ghudson]

Is the Data Entry property set to YES? It should be NO for what you want to do.

 

[godofhell]

Check the events on the form, you might have some set on onload, on open, on close, etc that might be setting some of those parameters in VB Code. If they are set through code you will not be able to affect your form by changing the properties of it.