Search results

Many Many hugz, back pats, high fives. That works perfectly! I did comment back in the code you commented out. All it does is keeps updating the DB field RolllinkID on the control table. Something the user wanted, sigh.

I thought about tab controls, but opted for this method simply because the user is far more used to this format.

Here is the file.

From the main form, the sub-forms properties Source Object is equal to one of the sub-forms. Should this be set to something else?

I tried to remove the linked fields and just use the sub-forms query to select the records. This still gave me no records. I then deleted the subform control off the main form, and added a new sub-form with no linking. Again, no data.

Looks like it would be the Master/Child linking that is the problem. The field in the Master/Child is the same across all the sub-forms, BUT, the queries on the sub-forms is unique to each sub-form. The code I am using right now is: Me.MainWindow.SourceObject = "Roll-Lists" I take it I need...

I have a form, sort of a menu, with a couple controls to set some parameters in a little database. On this form I currently have a sub-form control. What I need to do, is depending on which of several control buttons on the main form is pressed, the actual sub-form changes to be what the...

Yes that form, and its parent is Roll-Permits OK that seems to have worked nicely!!!! Sigh, something so simple has been driving me nuts for two days.

Here is the ACCDB in question, I am having issues with the Permits Forms..

Would it be of any use if I uploaded the ACCDB I am working on. No big deal, as there is no confidential data in this section.

Found it!!! OK, can see a couple issues I will have to work around. One confusing thing left tho. The Form when opened on its own, buy clicking on it in the Objects list still comes up with no data, yet when I look at the query that it is supplying the data there are three records. Also...

Going over everything it could very well be a table linking issue. Where exactly is the linking information stored is it in the calling Form, or the Sub-Form? I am looking around for it, and it is evading me....

The missing data could be a filter issue. The blank form is very odd. I have a Menu -> Form ->sub-form. If I directly open the 'Form' all its data shows up, but none of the fields in the sub-form. If I open the Menu and use it to open the Form than there are no data fields in the form...

With fields: Without Fields:

I have a sub-form/form created. When I open it as a form I get to see all my fields (with data missing) When this form is opened as a sub-form all the fields are missing The other odd thing is the query for the sub-form as 2 records in it, but these records no longer show up in either...

I have a sub-form that will have a random number of records depending on the calling form. It is important that the user know that they have looked at all the records. What I want to do, is pretty much copy what is down in the navigation part of a the sub-form "Record ## of 88" in the header...

Looks like your solution is working good for me also!!! Can not heap enough thanks on you for your insights!

Unfortunately the RollID field is not unique in any of the tables. Most of the tables, other than a couple import/control tables all have ID as an autonumber for the PK. Control is a necessary evil as I do need to store a couple user dependent variables across sessions. These are thrown into...

You are right. Now click on one of the control buttons at the top. Owner would be a good one, the two sub-forms become totally grey.

Here is a file!