Recent content by key1pop1

Hello all, Sorry if this question has been asked before I couldn't find anything exactly the same. I am having the following problem. I have three tables: Contacts_TBL Interests_TBL ConInt_TBL ConInt is has three feilds: ContactID InterestID RelationID (primary key) I have set this up in...

Hey all, So I have made a search form which looks up info on a table using VBA in such a way (text box version) If Not IsNull(Me.TxtFitLastname) Then strWhere = strWhere & "([Last Name] Like ""*" & Me.TxtFitLastname & "*"") AND " End If This goes on for several variables that add to a large...

Genius! I promise I am done with this topic now, thanks for all your help!

Thanks! So here is a follow up question that is a tad bit tricky. I have those subforms working like a champ. I have them set up so you can add/edit records and below the header(of each sub-form) is a 'multiple items' view of all the records. Is there any way to get rid of the right side scroll...

That was so easy I feel dumb, thanks man!

Hey all, My question involves 3 different tables (each table controls a combo-lookup box which I want to be able to add fields to at anytime, the tables just have 1 key field and 1 detail text field). All three tables are not related to each other, nor do they need to be. I wanted to save space...

Thank you for your reply, Yah, I was looking into using sub-forms but there are a couple different secondary tables that I will need to do this for so I think pop-ups will end up being the cleanest even if they are not the easiest solution. I will look up more on both methods you mentioned...

First off I apologize if this is in the wrong section and/or if this issue has been answered I tried searching for it before I posted. I have a form (say F1_FRM) that collects information on a production from a user. On this form there is a button which opens another form (F2_FRM) to add...