empty form

[June7]

Which form has which query?

How are you applying filter?

Is the result really a problem? Which do you prefer?

First image shows an actual record because it is not new record row. So why is your filter not excluding that record?

[guest]

yes that is the problem because is not updateable shows no new record. it looks ugly. doesnt change anyting just for look. button documents starts form frmDosie and its queries are Dosiea, Dosiea1 and Dosiea2. dosiea2 is made with join of the first two. if the form is updaeable when no results will show only new record. that way you see something. it is clear there are no records to show without it is little confusing.

[guest]

and one more thing. what record do you mean. there is no record. text under the combo boxes are field captions. records color is white.

[June7]

First image in your original post shows 1 record and it is not empty, there is data. How did you get that display? I cannot reproduce.

There is no UNION query in the db.

I applied filter for 2024 on frmDosie - form shows completely empty. I get an error when I try Combo42.

I am not really understanding issue. If there are no records to display and dataset is not updatable, form will be empty. That's the way it is. Users will learn. If they really need clarification, can have a MsgBox popup or a textbox on form with big red text display "No Records Found" when that is the case. Will likely need VBA.

Your search comboboxes act weird. Their lists only reflect values in the filtered dataset. So if you choose 9 from the starting list, only 9 is then available in the combobox list, cannot then choose 41 as criteria from list, have to type it in. Same for the year. Why? Combobox RowSource should not be the same query that is filtered by form.

[guest]

if only nine is available delete 9 from combo box and enter and than you start from beginning. its is instead reset button (with text box). don't use combo 42 its for printing records i deleted custom query and everything with it. button also no not finished yet. work only with first and last. first is number and last is year.

[guest]

according to everything we talked about (form works) but just because form is unapdateable when no records is found noting is shown. union query is with another form so i didn't put it here. seems except message box nothing else can be done if i understand good. if that is case it is ok. I tank you for your effort June7. should i close thread?

[June7]

Can mark "solved" if you want.

[guest]

thanks i will do it