Actualization query

[slbenfica]

Hello,
I have typed this criteria but it still asks me to input some word to do the search.
Criteria: Form![Consulta por obra].[Combobox name]
But after this the program input in the "Form" this type of brackets [].
When i run it, asks the name to do the search...


Thanks

[pbaldy]

Try

Forms![Consulta por obra].[Combobox name]

did you put the actual name of the combo in?

[slbenfica]

Hello,

Thanks very much. It is working now.
When i have more questions i will try to contact you.
Thanks again.

[pbaldy]

Happy to help. When you have more questions, just start a new thread. Always somebody around to help out.

[slbenfica]

Probably nothing. It is common in database design to store a numerical key value in related tables. In other words, if I have a employee table with an employee number and employee name, it is the employee number that I would store in related tables. I'd get the name by joining the tables in a query on the employee number field.

Hello again,

Regarding this question, i am doing a report and in the report it is appearing the number and not the name that corresponds in the column.
How can i fix this?

thanks

[pbaldy]

From the post you quoted:

I'd get the name by joining the tables in a query on the employee number field.

In other words, you base the report on a query that joins the two tables together on the number field. That lets you include fields from both tables in the report.

[slbenfica]

From the post you quoted:



In other words, you base the report on a query that joins the two tables together on the number field. That lets you include fields from both tables in the report.

And if the report is displaying data from a query that is searching in several tables?

[pbaldy]

You should be able to add the table with employee names with the appropriate join to the table with the number without affecting the records returned.

[slbenfica]

You should be able to add the table with employee names with the appropriate join to the table with the number without affecting the records returned.

sorry but i am not understanding...

[pbaldy]

Can you post the db?

[slbenfica]

Can you post the db?

It is larger than 2 MB, It is 3MB. How can I quote it?
Sorry, post it...

[pbaldy]

If you do a compact/repair then zip it, is it still too big?

[slbenfica]

Good idea,

The main table is called the "Lista de Tarefas" and the secondary table that has the info that is not appearing as text is the table "Nome da Área".

Thanks

[pbaldy]

Both reports in this sample get their data from one table. That said, your data seems messed up. The area field in the Lista de Tarefas table is text not numeric, and your relationships are set up on the text field rather than the numeric field. In other words, your database is set up for the text to be there, not the number.

[slbenfica]

Both reports in this sample get their data from one table. That said, your data seems messed up. The area field in the Lista de Tarefas table is text not numeric, and your relationships are set up on the text field rather than the numeric field. In other words, you database is set up for the text to be there, not the number.

How do i solve it?