I am having trouble finding out how to sort my headers. I would like to switch positions of the Group Header and Page Header so the fomat is like this:
Report Header
Group Header
Page Header
Detail
Page Footer
Report Footer
I have tried deleting the Group Header and adding it in again...
lespaul, dhookom, Thanks for your input. I was able to redo my database and get rid of the lookups in the tables. Everything seems to work great including the concatenations. Now, for a little twist to the concatenation. I don't know if this is do-able or not. In my example above, my table...
dhookom, thanks for the insight. Do you believe the lookups in the tables are causing my concatenation problem? I am early enough in my db design that I could change this. I suppose the alternative are queries as lookups in the forms? Am I thinking along the proper lines or can you...
I used dhookom's FAQ which worked great, however, I am having a problem. I have a table called tblLocations. It has 3 columns (Location ID, City, State). I have another table called tblTripDetails. In it is a field that uses a "look up" combobox to tblLocations. My concatenation query...
Zameer, That was exactly the problem. I suppose because I didn't use the link wizard, it did not create the requery for me. I assumed it was a requery that was missing. Thanks again.
Thank you Zameer. I did use that very form as my example. However, I must be missing something simple. It usually ends up that way. I can scroll through the recordsets in subform 1, but the recordsets in subform 2 remain the same, which is the corresponding recordset of subform 1, recordset...
I am trying to link a form with 2 subforms. The parent form links fine with the 1st subform. The 1st subform is supposed to link to the 2nd subform. So, when a recordset is picked on subform 1, it shows the corresponding records in subform 2. What I am getting is all the records in subform...
I am having some difficuly with this NotInList event. My problem is; I am entering the new resource, then I tab to the next field. I get the message box to add the new resource. I enter the new resource and the name is added as a record in the table, but not in the list of the Combo Box and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.