How to show data in Access Form

[ria.arora]

Dear All,

I have created Access database as a frontend application and another database as a Backend Database (all the databases are password protected). All tables and queries are stored in Backend Database.

My problem is that I need to create a form (Combo filters) with sub-form (List of the columns). I don't know how to show the data in this form / sub-form from backend database, I really need someone help for this.
Please let me know if someone has sample code for the same.

Highly appreciate your help.

 

[mahenkj2]

Front end and back end, so I think you have gone from the process of splitting the database! In that case, how do you have the queries in back end.

While using form and sub form, if you have relationship of one to many already defined then by using form wizard, when you select more than one table, the wizard ask you to select how would you like to see the data. So one table shall populate the main form and other shall sub form. So, if you change the data of combo, related data in subform will change automatically.

Hope this helps.

best regards.

 

[ria.arora]

I have not splitted the database. I have created two different databases. One database has only forms and other database has Tables and Queries only.

And Form / Sub-form both needs to be created from single table only.

 

[ria.arora]

Hi Pat

Thanks for the reply Are you saying queries should be in FE ?

If I'll keep queries in FE then I need to create tables as well FR, right?

I have only few queries in DB otherwise all queries are written in VBA code itself

 

[ria.arora]

Any idea how to show backend data in frontend application.

I have two databases FE and BE. And BE database is password protected. I need to extract data from BE database and need to show in FE in read only format and need to provide one button to change the data.

Any idea how to achieve that. Please let me know if someone has sample code for the same.

Highly appreciate your help.

 

[ria.arora]

Thanks Pat. But how to populate the data in the form. I'm sorry for basic question. Actually I'm now to Access world and have not created from to display the data.

Thanks a lot for all the help