G
Guest
I've got a form field (companyname) based on a table but selected through a
query. I made it a combo box whose control source is (companyname). I use
the combo box to select the company that purchased a particular item and then
I'd run a report to show what all that company purchased. One company has
changed it's name and I changed it in the dbase table and now when i run the
report, it obviously doesn't return any info because the new company name
hasn't purchased anything yet. I can change it back and the data will show
up.
I've got a companynumber field in the same table that I should have used as
my bound column. How can I change the combo box to base it on the
companynumber field but still show the new company name on the reports with
the previously purchased items? Hope this isn't too confusing. Help
query. I made it a combo box whose control source is (companyname). I use
the combo box to select the company that purchased a particular item and then
I'd run a report to show what all that company purchased. One company has
changed it's name and I changed it in the dbase table and now when i run the
report, it obviously doesn't return any info because the new company name
hasn't purchased anything yet. I can change it back and the data will show
up.
I've got a companynumber field in the same table that I should have used as
my bound column. How can I change the combo box to base it on the
companynumber field but still show the new company name on the reports with
the previously purchased items? Hope this isn't too confusing. Help