Cilla:
Many thanks for your suggestion. I apologize for not responding sooner,
but was on holiday. It worked beautifully and has solved all my
problems.
Kindest regards,
Miguel
Cilla wrote:[color=blue]
> Miguel wrote:[color=green]
> > Dear Egidio,
> >
> > I hadn't thought of using that function and will give it a go. Many
> > thanks.
> >
> > Miguel
> >
egidio.caldeira@gmail.com wrote:[color=darkred]
> > > Miguel wrote:
> > > > I have synchronized combo boxes linking Account Type with Customer
> > > > Names based on the template that Microsoft has in one of its samples
> > > > databases. There are the appropriate relationships between the Account
> > > > Type Table and the Customer Name Table based on the ID field, so it is
> > > > the ID field which is stored in the main table. However, in the form,
> > > > the Account Type and Customer Name are displayed because the column
> > > > width property has been changed to hide the other columns. But, when it
> > > > comes time to create reports, it is the ID field that comes up whereas
> > > > I need the text equivelent of the Account Type and Customer Name to be
> > > > displayed. How do I replicate what is on seen on the form in a report.
> > > > I suspect it would be done with a special query which would be the
> > > > source for the report, but do not know what method to use to get text
> > > > equivelent of each of the two fields.
> > > >
> > > > Any assistance would be appreciated.
> > > >
> > > > Miguel
> > >
> > >
> > > Hi Miguel,
> > >
> > > Have u already try to use the code DLookup? I think it will do what u
> > > need.[/color][/color]
>
> On a report you can also have a combo box to display the account type
> text or the customer name instead of the id number. When it is
> displayed in print the combo will not show up as a combo but will show
> the text instead of the id. On the combo box make the combo have two
> columns id and text, make the column size 0;3 for example so the text
> appears and the id is hidden.[/color]
