Search results

Bob.. you make it look so easy... :) And after looking at your code it looks so logical. No wonder I don't make a living at this.... I could starve to death if I did. You rock! Thank you very much!

Bob.. one question? What would I have had to have done if each of the vl tables had a different field name? Instead of "= [Value]" in your line of code, how would I have referenced each table field name? Just curious because I attempted all types of "Public" statements, a lot of different...

I have attached a zip file that contains the two mdb files. I have configured the subform back to the condition I had when I first posted. Again, thank you for your time and your willingness to help. I am getting an education in Access for sure...:)

Oh I forgot.. Galaxiom was quite correct about the redundant code and I really do appreciate his suggestion to simplify the code. See Below: Private Sub optValueLists_AfterUpdate() Select Case Me.optValueLists Case 1 strInput = "vlStatus" Case 2 strInput =...

My solution is not at all that creative but after eight hours of giving my monitor blank stares I decided on a brute force solution. I have ten tables that I use to hold different value lists (basically used as look up tables) and in my main form (frmMaintenance) I created an option group so...

Thanks for the help? I found a solution (it's not elegant but it works)! if anyone is interest you can post a reply to this thread.

I have a main form (frmMaintenance) with a subform (frmMaintenance_Subform). The subform has only one unbound control (text box) that I want to use to display records from different tables. I have been able to set the data source of the subform using VBA (see code below) Private Sub...