Navigation Form - Using My DB's Forms under it's SubForm Control

[SoleAris]

Hi all,

Been actively trying and searching for a solution, however to no avail in the past couple of days. So here I am.


I am attempting to create a Navigation Form to allow another computer in my network to be able to utilize necessary forms within a database (through RunTime). I was hoping this would be a clean task by simply loading the forms into the tabs of the Navigation Form, however that is clearly not the case.

For starters, When attempting to use a form that has some VBA behind it (Docmd.ApplyFilter based on a selection from a combo box), I am given the error stating:

"The action or method is invalid because the form or report isn't bound to a table or query."

After searching on this error, I believe it's because my Navigation Form does not have a record source. If this is the case, then I am confused as to what record source it should have, as with the 3 forms I need to access through the Navigation Form all pull data between various tables and queries within the database (some not related).

How do I go about this dilemma?


----------------------------------------------------------------------------

Now I've also come to the conclusion that my VBA references now must change in order to correctly use my forms. A correct reference would look something like:

[Forms]![Navigation Form]![NavigationSubform].[Form].[My Form's Control]

Is this necessary in order to write any events, such as an AfterUpdate on a combo box?


Thanks for the help in advance! This is very cumbersome :banghead:


- SoleAris

 

[rzw0wr]

Are the tables with the database or is it a split database?

I am attempting to create a Navigation Form to allow another computer in my network to be able to utilize necessary forms within a database

Does this new user have there own copy of the database?

Dale

 

[SOS]

Best to avoid the DoCmd type commands at times because Access doesn't always know which item you want to use with it. I would use the filter explicitly:

Forms!FormNameHere.Filter = "xxxxx"
Forms!FormNameHere.FilterOn = True

 

[SoleAris]

Are the tables with the database or is it a split database?

The tables are linked to a SQL Server back end.

Does this new user have there own copy of the database?

In past versions, there are only 2 users other than myself who access this database, so we've kept it as a single copy. Probably would be best with this new version to give each user their own copy of the database.

 

[SOS]

The tables are linked to a SQL Server back end.



In past versions, there are only 2 users other than myself who access this database, so we've kept it as a single copy. Probably would be best with this new version to give each user their own copy of the database.

It is ALWAYS best to let each user have their own copy of the frontend. It is even best to split when it is a single user. It helps avoid corruption and reduces the chance of losing the entire thing.