Unanswered: Help With Relationships - Can't see all records
This is a strange problem I hope someone can help..
TableA is a customer table and TableB is a Notes table for the customer. Not every customer has a note in tableB. When I click on the button for finding a Customer, even though the customer exists in TableA, if there is no entry in TableB, I can't pull up the record.
Here is the code from the control, if that helps.:
Private Sub Find_Book_AfterUpdate()
glad to hear that worked but just had one question to ask. Did you already have the Relationships for your tables set? One-To-Many? I know you can do it in the query, but thought if you had tables already related it would pull the data over anyway, at least that's the way all of mine work without having to do it in the query. Just asking.