code behind my form - urgent

sc2227

New member
Local time
Yesterday, 22:54
Joined
Mar 5, 2017
Messages
9
I am using Access 2016, I have built a database containing 3 tables, 1 query, 1 form, and 1 report. The 3 tables have a linked relationship to each other, the form generates a report by running the query in the background. I can get the SQL code of the query, but how can I get code for the form I made. It is a search and retrieve records form, but it is actually a complex form where it filters upon cascading menus and displays records based on this. thanks in advance.
 
Do you mean:- How do you get access to the code behind a form? In other words the code that is in the code module that is part of the form?
 
Actually rereading your question, I think you are trying to find out where the Form keeps the filters and things. Would that be a better description of your problem?
 
As Uncle G has hinted at, we really do need a clearer picture of what, exactly, you're asking, here, in order to help you!

To be honest, having 3 Tables, but only 1 Form, is troubling in and of itself! How is data being entered into the Tables? Hopefully not by entering it directly into each Table...but a Form based on three Tables is almost assuredly Read-Only.

Linq ;0)>
 

Users who are viewing this thread

Back
Top Bottom