M
Mark Andrews
I have been trying to make use of the Access2007 datsheet filtering
functionality (those arrows on every column).
Here's my situation:
Normal database design with tblCompany and tblContact where tblContact has a
foreign key "CompanyID".
So on the datasheet that displays Contacts I show a combobox based on
CompanyID "select CompanyID, CompanyName from tblCompany" and hide the first
column and only show the companyname.
If I use a name for the combobox control such as "ComboCompany" when you go
to sort the datasheet it causes weird behavior and after filtering prompts
for "ComboCompany" however the work around is to always name the controls as
fields names (example if I name it "CompanyID") it works fine.
I tend do do regular forms and then copy all the control to datasheet forms
and this little bug is just annoying.
Anyone know a fix?
Mark
PS: Also if you use any sort of alias in the sql of the combobox it causes
filtering to not work.
functionality (those arrows on every column).
Here's my situation:
Normal database design with tblCompany and tblContact where tblContact has a
foreign key "CompanyID".
So on the datasheet that displays Contacts I show a combobox based on
CompanyID "select CompanyID, CompanyName from tblCompany" and hide the first
column and only show the companyname.
If I use a name for the combobox control such as "ComboCompany" when you go
to sort the datasheet it causes weird behavior and after filtering prompts
for "ComboCompany" however the work around is to always name the controls as
fields names (example if I name it "CompanyID") it works fine.
I tend do do regular forms and then copy all the control to datasheet forms
and this little bug is just annoying.
Anyone know a fix?
Mark
PS: Also if you use any sort of alias in the sql of the combobox it causes
filtering to not work.