Novice
Windows 98/ME 
Access 2003
I have two forms
A main form - frmManager with ManagerID and DivisionID
Another form - frmDivisionOrder with ManagerID and DivisionID and Division
I want to sort my main form by Division.
What code can I put in to pull that info.
I also have a dlookup on the main form pulling the Division so if I can sort off of the dlookup that would be great.
Thanks!
Administrator
Windows 10 Access 2013 32bit
If I understand your question correctly, You would do that with an ORDERBY clause in the RecordSource of the MainForm which should be a query and not directly to a table.
Novice
Windows 98/ME Access 2003
the record source is a table. I have to have it updatabale and by the time I add ALL of the tables (4 of them) I can no longer update to the form.
Administrator
Windows 10 Access 2013 32bit
A query is updateable under most conditions. Are you saying your table is made up from 4 different tables? I believe this link will be helpful.
Novice
Windows 98/ME Access 2003
That article helped alot and I think I've identified the problem.
One table has ManagerID as an autonumber and the other has ManagerID as a number.
It is this relationship that isn't working to allow updates to the form. The records are identicle. Any suggestions?
Administrator
Windows 10 Access 2013 32bit
An AutoNumber PrimaryKey *should* be a LongInteger field in another table as a ForeignKey. Is that what you have?
Novice
Windows 98/ME Access 2003
Whoa.... you're going to lose me.
In Table: Manager District - the ManagerID is a long integer (not primary key)
In Table: Table Managers - the ManagerID is an autonumber and there is NOT a primary key for the table
when I put both tables in a query they do not automatically join like other fields. I can join them and it all works fine (at least I think it does) but that is the element in the form that is not working.
Administrator
Windows 10 Access 2013 32bit
Does Table: Table Managers have a PrimaryKey and if so, why isn't it the ManagerID field?
Novice
Windows 98/ME Access 2003
It was in the ManagerID field. Some of our managers have more than one district so I overwrote the table and now have duplicate records and it won't allow me to add the primary key to the ManagerID field.
Administrator
Windows 10 Access 2013 32bit
Oops! I would think that a Manager has one ID but can be in more than one District table as a ForeignKey.
Novice
Windows 98/ME Access 2003
Yeah, I think I messed up...
Administrator
Windows 10 Access 2013 32bit
Is it fixable? Does the District table have a ForeignKey field for the ManagerID?
Posting Permissions
Reply With Quote