Acces form

%3CLINGO-SUB%20id%3D%22lingo-sub-1600768%22%20slang%3D%22en-US%22%3EAcces%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1600768%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20access%202019%20the%20Form%20is%20missing%20data%20although%20it%20is%20in%20tables%20and%20quires%20any%20idea%20it%20us%20to%20be%20in%20form%20but%20has%20gone%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1600768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601307%22%20slang%3D%22en-US%22%3ERe%3A%20Acces%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765418%22%20target%3D%22_blank%22%3E%40Littleton46%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20there%20are%20many%20possible%20things%20that%20are%20involved.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20be%20more%20specific%20about%20the%20problem.%20What%20data%20is%20%22gone%22%3F%20How%20do%20you%20know%20it%20is%20gone%3F%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20the%20form%20bound%20to%20a%20table%2C%20or%20to%20a%20query%3F%20Or%20unbound%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThe%20more%20detail%20you%20can%20provide%2C%20the%20better%20the%20chance%20of%20someone%20being%20able%20to%20figure%20out%20which%20of%20the%20many%20possible%20problems%20is%20most%20likely.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20fact%2C%20the%20best%20strategy%20might%20be%20to%20upload%20a%20sample%20copy%20of%20the%20Access%20relational%20database%20file%20in%20question%2C%20along%20with%20an%20explanation%20of%20which%20form%20is%20the%20problem%20form.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am using access 2019 the Form is missing data although it is in tables and quires any idea it us to be in form but has gone

2 Replies
Highlighted

@Littleton46 

Unfortunately, there are many possible things that are involved.

 

Please be more specific about the problem. What data is "gone"? How do you know it is gone? 

Is the form bound to a table, or to a query? Or unbound?


The more detail you can provide, the better the chance of someone being able to figure out which of the many possible problems is most likely.

 

In fact, the best strategy might be to upload a sample copy of the Access relational database file in question, along with an explanation of which form is the problem form.


Thanks.

Highlighted
I'd open the form in design mode and validate that you didn't accidentally save a filter. Also check the recordsource, test it to make sure it is returning all the records.