empty form

[guest]

Hi,


I have two forms based on their own query from a single table (same for both forms). each form has same combo box. if there are no results from searching one shows empty record while other show none. why the second is different.

[CJ_London]

best guess is one query is updateable, the other is not. Or one form allows additions, the other does not

[June7]

Why two identical forms? Or almost identical. There must be something different in property settings. Would have to examine to analyze.

[guest]

same principle show different records. this are for catching mistakes. show me all records with mistakes if none found mean no mistakes everything is fine. what confuse me that code/macro is identical query same made same way only difference is that they search for different mistake.

[June7]

Still, why need two forms for this? Are you using queries with static filter criteria? I would use one form and VBA to change filter of form.

[guest]

i don't know vba so for now i work with queries. is important for me to solve all things i want, later i will do that with vba but i need time for that and with this i can work right now. do no need to wait. what is meaning of static filter criteria?

[June7]

Static means it is not dynamic, not dependent on user input, it is hard-coded in query, like: WHERE Category = "ABC".

It is possible to have dynamic input without VBA. Query would reference a control on form for user input, like: WHERE Category = Forms!MyForm!MyTextbox.

[guest]

most are static. in the examples i choose year to show me mistakes for chosen year. form is already filtered with the criteria from the query.

[guest]

I checked my forms and from all forms that i have only two have this problem. I noticed that they don't have new record so i guess CJ_London was right they are not updateable. forms that don't have problem are based on simple select queries with one or more criteria. those of the forms that have problem are little more complicated one is union query and the other one is made with join of two other queries.

[June7]

A UNION query is never updatable.

A query that is a join of other queries might not be updatable.

[guest]

so how can i fix those two forms.

[June7]

Do you want to edit data? Then use updatable queries.

Why are you using a form for these queries? Maybe should be reports.

Don't know enough about your requirements to advise specifics.

[guest]

one of the forms is only for selecting and printing. actually second too not for editing just preview and printing. i already have reports they work perfectly but want to see something bigger like the form and there i can chose what to see (have more options that way).

[guest]

even these two forms work ok if there are records to return. problem shows only when there are no records to return.

[guest]

here i send you my database tell me what you think. form name is Documents. Delovodnik.zip