Solved Form not opening to filtered record (1 Viewer)

Kayleigh

Member
Local time
Today, 05:08
Joined
Sep 24, 2020
Messages
706
So I'm back with my COVID database.
Summary form works great. But when try opening form filtered on related records from there, it just opens blank! I've checked datasource and can't see where it can go wrong - queries all run fine.
Don't think problem is with the code - it works to open other forms. Only these two forms (DEfrmCovidTest and DEfrmCovidConsent) will not perform.
What else can I do to resolve this?
 

Attachments

  • CovidTest_3.accdb
    1.2 MB · Views: 127

MajP

You've got your good things, and you've got mine.
Local time
Today, 01:08
Joined
May 21, 2018
Messages
8,463
It opens blank because they are set to data entry. Is that not what you want?
 

Kayleigh

Member
Local time
Today, 05:08
Joined
Sep 24, 2020
Messages
706
Correct but I would like to be able to view previously entered records.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 01:08
Joined
May 21, 2018
Messages
8,463
Data entry means that form opens to a New record. If you do not want that then change it.
 

Kayleigh

Member
Local time
Today, 05:08
Joined
Sep 24, 2020
Messages
706
Great thanks for clarifying. Always learning new things:)

Btw I'm flattered that you take such an interest in my posts!
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 01:08
Joined
May 21, 2018
Messages
8,463
FYI,
When you use docmd.open form you can specify the datamode for the form. If you want to be in add or edit mode. However without navigation buttons, your form would be useless in the edit mode. No way to get off the first record.
 

Users who are viewing this thread

Top Bottom