By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

Matching Report with Form with data from Synchronized Combo Boxes

P: n/a
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

Jun 15 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a

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.

Jun 15 '06 #2

P: n/a
Dear Egidio,

I hadn't thought of using that function and will give it a go. Many
thanks.

Miguel
eg*************@gmail.com wrote:
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.


Jun 15 '06 #3

P: n/a

Miguel wrote:
Dear Egidio,

I hadn't thought of using that function and will give it a go. Many
thanks.

Miguel
eg*************@gmail.com wrote:
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.


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.

Jun 15 '06 #4

P: n/a
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:
Miguel wrote:
Dear Egidio,

I hadn't thought of using that function and will give it a go. Many
thanks.

Miguel
eg*************@gmail.com wrote:
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.


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.


Jun 22 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.