filter not allowing record add

[arage]

To my horror I’ve discovered that my form while appropriately filtering based on the user logged on, it will not execute a new record button I’ve installed. I get error message ‘you cant goto the specified record – you may be at the end of a record set’

Well that’s obvious, I’m only seeing filtered records, but how am I going to bypass this and start data entry? Are you telling me that I have to remove the filter and then start data entry? But that wud be terrible as then then the data keyer cud see ALL records not applicable to him/her and that’s a security problem for me. I want the form filtered when opened and if the new record button is pressed then add a new record, not to the record set but the entire table.

Wud appreciate any thoughts.
thanks

 

[BarkerD]

Applying or removing a filter should have no effect on adding a new record. You should check a couple of things.

1. Security Settings
2. Form properties - set to edit only
3. Recordsource of the form may not be updateable if based on multiple tables.

Duane Barker

 

[arage]

1.i haven’t done any security settings yet.
2.edits, deletions,additions, and data entry all set to yes, your advice didn’t change anything, data entry was still crippled if only set to edit only.
3.form sql statement: query builder shows 3 table involved, how can I be certain this is not the cause? The 3 tables were working fine before I did ‘something’ and now the form is disabled from receiving records somehow.

 

[BarkerD]

The best way to check if the query is updateable is to run the query and then try to add or change a record.

Duane Barker

 

[arage]

Well, i cudn't add a rec b/c the query told me i'd create a duplicate record somewhere but i looked after that and made sure that duplicate entries were allowed in the tables.

can u mention the quickest way to find the field causing such an error in the query?

also, if i get the above message then is it fair to assume that the query IS updatable, its just that the duplicate record is getting in the way?

 

[arage]

ok i created a record and i changed a record so therefore the query is updatable.

HOWEVER....

going back to my user form, when i try to manipulate any data there i notice in the status bar 'THIS RECORDSET IS NOT UPDATABLE'
message.

the allow properties (add,deletions..etc) are all set to yes in my form. the query i used to build the form i successfully added and changed records in also.

HOWEVER...

my form's default scroll keys still have the new record button disabled.

i was so close and now this has got to happen. am i going crazy?

 

[arage]

above I made a mistake when discussing my query problem. I didn’t add or change a record in the query I created, I was forced to create corresponding records in the base tables before I saw any update to the query. In the query I could make changes to whatever records I want & the changes wud then filter down into the corresponding tables. But I cud never add a new record to the query b/c of the invalid/duplicate index message I’d get which is odd, b/c the rules I set up aren’t that complicated and the data I was trying to enter in my query didn’t exist in my tables.

So what do we know?

I can CHANGE my query values however I want and the tables will show the corressponding changes. But I cant ADD a record b/c of an index error message I think is invalid. The data I’m trying to enter in the query is not accepted, but the same data when entered into the underlying tables will show up in the query. Which leads me to say why wudn’t the query accept the values when I was trying to enter it in there?

One curious thing is that both tables MUST contain the related info before it shows up in the query. I can’t just have one table with info in it and & expect to see it in the query (both tables must contain the information before it appears in the query) why?

Any suggestions wud be appreciated.
Thanks