Search results for query: *

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...

shannonp This is exactly what I want to do as well. Only probelm is I don't know where to put this code. Is it a form Module? OnExit event?

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...