I have a database with multiple tables, the multiple tables consist of Account Information and then Call Reports I need to build a Report that will show a history of the Accounts and their reports. All of this is very simple but what I would really like to do is call a form that lists the companies in the system in a combo box and then after clicking one of the companies having it open a report which I have built with the required information. Please help me I have been ripping my hair out over this....Thanks in advance
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Call form from query
- Thread starter jabz
- Start date
try this:
write a query with a where clause that looks like this:
(([Time Card Hours].[WeekEnding])=[forms]![TimeCardsnew]![combowkend]));
create a combobox that looks up values in your table in the companyname field. base the form and report on this query.
If you get going and need more help let me know.
Russ
write a query with a where clause that looks like this:
(([Time Card Hours].[WeekEnding])=[forms]![TimeCardsnew]![combowkend]));
create a combobox that looks up values in your table in the companyname field. base the form and report on this query.
If you get going and need more help let me know.
Russ
- Thread starter
- #3
I did the clause but now in the form when I click on a company name it says "Control can't be edited; its bound to unknown field 'company'".....what does this mean do I have a property mistake or could it be the fact that i'm using more then one table in the query???
- Thread starter
- #4
- Status
Similar threads
