Reports used as Invoices

[Nona]

I have created a database using 2003, that , in addition to other reports,
will generate reports used as invoices. There will be at least 5 different
types of invoices but many, many different contracts. I've created the
various tables, and they work well. To get the invoice, the user opens a form
that lists the different type of invoices, then a query asks that the user
input the contract ID number which produces the data related to that contract
on the invoice.

This works well and gets the correct results, but I anticipate some
resistance by users in having to remember and input those contract IDs. Is
there another way to do this? Say a lookup function for the contract name so
they just click on the contract name for the report?

Thanks in advance for any assistance.

 

[Arvin Meyer [MVP]]

Sure just use a 2 column combo or listbox, hiding the ContractID
(columnwidth property set to 0) but binding it to the combo(listbox) Then
feed the ContractID to the report:

DoCmd.OpenReport "MyReport",,,"ContractID =" & Me.cboContractID

 

[Nona]

Success! And Many Thanks to You!

I've added the combo box (with the Contract IDs) to the form that lists the
names of the reports. So now there are two combo boxes on that form. At least
they will be able to immediately look up the Contract ID to enter when they
are prompted to do so.

My skills as a programmer are extremely limited and this is probably a
stupid question, but I'll ask it anyway. Would it be very complicated to link
those together, so when a user clicked on the Invoice report "UCR" from the
list of available reports, it would open the list of contracts so they could
choose the contract that way?

I hope the question at least makes sense!

Again, thank you very much for your help.