Query stopped allowing adding records to table

[SC in Texas]

I have a form used to assign work orders to a particular crew member.
it has been working well until the past few days.
When I set up a filter on the table to restrict to the crew member, it
allows edits and adding new records. When I restrict to a particular date,
it allows edits but does not allow adding new records. Any ideas why the
change.
Thanks,
SC

 

[KARL DEWEY]

Do your datetime activities have a time component?
If you say for a particular date then it is for midnight of that date. Any
entry with time after midnight will not match.

 

[SC in Texas]

Thanks for the reply Karl.
The time component has not been a problem in the past.
It will list all existing records for the date, it just stop allowing adding
new records.
It has worked for the past six months but now it won't. Has Microsoft had an
update that might have changed this.
SC

 

[Dale Fye]

Have you recently upgraded to Office 2003, SP3?

Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Dale Fye]

How are you "setting up a filter" ?

Dale

--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[SC in Texas]

Dale,
I originally had a query joining the table that records the assignments made
by the foreman, fields are: SWRNOAssigned, EmployeeNoAssigned,
EquipmentNoAssigned, DateAssigned) with the original SWR table which has all
the street information, person requisting etc. to show in a form which the
foreman used to make the assignments. He has combo boxes available to pick
the appropriate info for each field. This was working fine. It was
referencing a form for the report date and employee number to filter by. It
still works for bring up existing records and allows me to edit them. It just
does not allow creating a new record like it use to.
I have also tried just building a filter sql statement in the forms property
for data source.
Thanks for the interest.
SC

According to the About Access on the help menu I have Access 2003
(11.8166.8172) SP3