Combo box with only one entry appearing

[martaw]

Hello, I'm using access to build a new database for my project but as a non-experienced user i've been having some difficulties that tutorials and other sources don't give me a clear solution to my problem. First, i would like to now how can i program to appear on a report a single entry that i selected in the combobox in the table instead of all the options and just enlighten the one i selected.



Also, if someone could give me an easy explanation on how to set one page for each entry because the format > details > force new page after selection is not responding..

Thank you in advance for your attention.

Best regards,

Marta Wadsworth

[martaw]

I've already solved the second problem.. so i just need help for the first issue

[orange]

You may wish to review the info here
http://access.mvps.org/access/lookupfields.htm

[martaw]

You may wish to review the info here
http://access.mvps.org/access/lookupfields.htm

Sorry, i didn't understand..

[orange]

Based on your post, I thought you were using lookup fields at the table level. And that's why I sent the link I did.

However, if you are not using table level lookups, what exactly is the issue.
Can you describe with some sample data?

I have acc2003 and can not use accdb format. I can only open mdb format data base.

[martaw]

that picture is the image from layout view of my report.. as you can see at "pick-up", "destino", "veículo", etc. the combobox appears showing all the posibilities and just enlightens the one I selected.. I would like to know how can i make it appear just the selection and not all the entries from the mother table.

Thank you for your help!!

[orange]

What is the rowsource of your report?
Is the image you provided a Form that you use to create records?
Can you post a jpg of your tables and relationships?

[martaw]

The rowsource of my report is a table called Serviços (in the picture) that is based from other tables and the report is from that table "serviços". The picture i provided before is from the layout view of the report itself.
There's also the picture from the relationships added.

[orange]

Can you save a copy of your data base (with no confidential data) in mdb format and post it?

I believe you are using lookups at the table level that may be causing some of your issue.

[martaw]

databse.zip

I've added the db in mdb

[orange]

It appears to me, and I don't understand Portugese, that you have not identified , nor created, the specific records you want to report.

If Serviços is Services, then I think you want to have a table containing info about Client selected services.

For example:
Service 1 was Requested on June 17,2012 at 6:25 PM to be Picked Up at the Luxor Hotel with a Destination of Paris in vehicle Cadillac with Licence 234_p_L-45 by client Hector Sanchez ( and I assume Pax and Voo are something like Number of People , phone or email?).

But you do not seem to have such records. You are using ComboBox at the table level. The recommended approach is to use Combo box(es) on Form(s) to select the appropriate values for a record that you will save to a table. The combo boxes use queries or tables as record sources to show the options available for that combo (Destination), and another for Vehicles etc.
How did you enter the data into the Serviços table?

You would NOT normally allow data entry directly into a Table. You use a Form for that so that you can control and validate what values get stored in underlying table(s).

If I have misunderstood, then please clarify.

[martaw]

Hey,

I understood everything you said and yes i'm using forms to introduce data such as the forms for clients, pick-up, destination, etc. then those forms give information to the report "services" ..

and i guess it is working because when you select the option on the form services it appears "enlightened" in the report :s

[orange]

I don't have 2007.
How did you put the 2 records into the Serviços table?

[martaw]

In the table because when i created the form for "Serviços" it didn't appear the posibilities of the combobox

[orange]

So you added the data into the table directly?