Sorting in a form with 2 subforms...

D

Dan

I created a form in Access thet contains 2 subforms. The first is subDetail and the second is subDatasheet. Both sub forms use the same table. The tabel contains names, addresses, phone numbers, etc. I have 2 subforms set up so one can show a scrolling list of all records and the other is a "detial" type of form. The 2 subforms are tied together by this code:

Set Me.subDatasheet_xxx.Form.Recordset = Me.subDetail_xxx2.Form.Recordset

Now, when a new record is added to the main table it is sorted properly (by last name). But when I try to sort the records in the form view (with the 2 subforms) they do not sort properly and the joining code does not work.

Any suggestions would be much appreciated!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Unremovable horizontal scroll bar on subform 1
Highlight rows in a subform datasheet view 0
First Subform record gets modified when closing form 3
Syncronise Scroll Bars on 2 Subforms 0
Syncronise Scroll Bars on 2 Subforms 0
What am I doing wrong 4
Set focus in a specific record within a subform 1

Top