Solved Form editing blocked whilst properties are OK (1 Viewer)

Dippies

New member
Local time
Today, 13:58
Joined
May 21, 2020
Messages
14
Good day all,
I have a strange problem.
I created a table with daily appends from outlook via a query and an append query.
The append data file has the date signature of outlook as a key field with no supplicates.
The input query lists all my input box entries.
Appending each day would have a result of a progressive duplicate errors except for the new days entries.
This worked for 5 days and 236 records. Worked on the data file last night. (no appends done just editing data)
Today I ran the append query, found one entry but I can't edit the data file via the form, BUT in sheetview I can change the data!!!
The new record icon at the bottom of the screen is grey, hence no addition either.

Appreciate your input,

Blessings,
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:58
Joined
May 7, 2009
Messages
19,175
check the Recordsource of your form.
 

Dippies

New member
Local time
Today, 13:58
Joined
May 21, 2020
Messages
14
On the Property sheet Additions yes,
Can the form "switch off" the record editing?
I have not touched the forms and record properties
I am in the dark.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:58
Joined
May 7, 2009
Messages
19,175
how about Data Entry is it Yes?
what is the Record Source of the Form, table, query?
 

Dippies

New member
Local time
Today, 13:58
Joined
May 21, 2020
Messages
14
I got the promlem.
I linked in the backend of the form the query to another query to set a sort sequence for the form end the new input record did not have an corresponding field value in the sort sequence file.
Thanks.
Blessinbgs
 

Users who are viewing this thread

Top Bottom