Values from comboboxes at reports

[dealwi8me]

I have a report of a table in which some of the fields are comboboxes with values (etc 2,3,...). These values are attached to values in antother table.(etc 2->User, 3->Admin...)

If i want to have a report with the User,Admin values (of the given record)instead of 2,3 how will i do it?

Thank you in advance

 

[Ally]

There are a couple of ways.

Personally, I think the best (and easiest) way is to do it via a query where you pull the data from your main table and the info you wish to look up, from the other table(s).

Alternatively, you could do it via a DLookup function (if you look that up on Access help it will give you all the info you need).

If you have any more questions, post back.

 

[dealwi8me]

I did it with a query and worked.... tnx