multiple control sources on one form

[jezh]

hi guys, im doing a uni project in access for a small business and the problem i have is that i am making a booking form, and on there needs to be
owner details,
animal details, and
booking details.

these all need to be entered when making a new booking, the problem i have is that i can only seem to be able to use one control source (from the owner table) how do i use multiple control sources on that one form?

Jez

 

[Pat Hartman]

You actually need a form with a subform. But rather than using tables as the RecordSources, create queries that join the related tables and use the queries as the RecordSource for your forms and reports.

 

[jezh]

ok right i figured out how do do that, thanks a lot very helpful. what i need to do now is to create a search facility. somthing along the lines of a string to search against a table or field.

also i need to create reports based on queries showing patters of things like income, averages, and broken down into months etc. anybody have any ideas?

 

[jezh]

ok right i figured out how do do that, thanks a lot very helpful. what i need to do now is to create a search facility. somthing along the lines of a string to search against a table or field.

also i need to create reports based on queries showing patters of things like income, averages, and broken down into months etc. anybody have any ideas?