Is it possible to create a form that has a Record Source from two tables? I need to display two tables in one form, but I'm finding it quite impossible. Also these two tables are absolutely unrelated, so I don't think a Query would work. Also I'm not only trying to display these tables in one form, but I'm also trying to filter what is being displayed. Basically I will have another form that will allow the user to search the database. Once they hit 'Search' this new form will open displaying the results from both tables. Help is very much appreciated.
Displaying Two Tables in One Form
- Thread starter deville75
- Start date
boblarson said:
Ya I tried Subforms. It works! But theres another problem. How do I filter the search. Every time I try to ApplyFilter it gives me an error saying there are no tables bound to this form. It makes sense though; tehre are no tables bound to the main form, but there are tables bound to the subforms. So I tried SelectObjectto actually select the Subform, but it seems that tries to look for the form being open on its' own, so it didn't work. Then I tried GotoControl. I'm having trouble with this as well. I just can't seem to ApplyFilter to the Subforms.
Ok well I until I get some help on how to ApplyFilter I'm going to do it this way: I'm going to display all the forms in seperate windows rather than as subforms in another form. This does make it messy though, with so many windows popping up, so I'm using MoveSize to resize and position them in a nice way to look at. Until I figure out how to us Subforms this is my solution. So if anyone can still help with subforms that would be great.
Thanks
Thanks
