Problem with Retrieving records into Access form

  • Thread starter Thread starter Vlad D.
  • Start date Start date
V

Vlad D.

I have created an "Action Items Database" using MS Access 2003 to
assign action items to members on my team.

The Form that I use to enter information can submit the information to
the table, but cannot retrieve any records. Upon each launch, it says 1
for the number of records.

Perhaps the problem has anything to do with:
1 - On the form, I use a disabled Autonumber to assign an ID to all
Action Items and have a Search records button.

2 - Also have some drop down Combo Boxes that feed off other tables to
show the Criticality of the Action Item (High, Medium, Low) and Status
(Open, On Hold, Closed)

Please HELP.

Thanks
 
Vlad said:
I have created an "Action Items Database" using MS Access 2003 to
assign action items to members on my team.

The Form that I use to enter information can submit the information to
the table, but cannot retrieve any records. Upon each launch, it says 1
for the number of records.

Perhaps the problem has anything to do with:
1 - On the form, I use a disabled Autonumber to assign an ID to all
Action Items and have a Search records button.

2 - Also have some drop down Combo Boxes that feed off other tables to
show the Criticality of the Action Item (High, Medium, Low) and Status
(Open, On Hold, Closed)
Click to expand...


Ot sounds more like you have the form's DataEntry property
set to Yes.

Or maybe the form's recordsource query has a criteria that
fails on all records.
 
Back
Top