Recent content by quest

Good advise problem is that i am beginner haven't learn about vba yet so i still trying to guess right way. and about fields i think no need to check. As i said i have few combo boxes. each combo is for number or text or date only. one for numbers other for text etc.

It shouldnt? works perfectly with no mistake.

I have few combo boxes so there are text, numbers, dates. in the example i tried with first combo which is number.

I tried few different ways none worked. last attempt was with this code: Private Sub Combo13_AfterUpdate() On Error GoTo Combo13_AfterUpdate_Err DoCmd.SearchForRecord , "", acFirst, "[Number] = " & Str(Nz(Screen.ActiveControl, 0)) DoCmd.Requery "" Combo13_AfterUpdate_Exit: Exit...

your suggestion is ok it works when set limit to list properties to yes but i want customised message box.

here how it is look like when nothing found only this example is with text boxes instead of combo boxes.

If nothing found i have only one new record.

i got no message i want to add one when nothing found.

I suppose it should be some iif statement in the after update of the combo box?

choose from combo box or write to it. I must say everything work just fine just want some message to appear to look better and show what is going on.

Hi, I have a split form with few combo boxes. I want to get message if search find no records. How that should be done.

I solved it. it shoul be like this IIf(Year(Min([EnterDate]))=Year(Max([EnterDate])),Year(Max([EnterDate])),Year(Min([EnterDate])) & "-" & Year(Max([EnterDate]))). need to switch year and min. thanks

Report is based on query. expression =Min(DatePart("yyyy";[EnterDate])) & "-" & Max(DatePart("yyyy";[EnterDate])) is written in the control source

now with correction do not except it all.

I got message wrong number of arguments.