Search results

Welcome to the forum. The following Code in the Form's On Current Event Should do the trick; If Me.NewRecord = True Then Me.YourCounterField = Nz(DMax("YourCounterField", "YourTableName"), X) + 1 End If Note; Replace X with your seed number (the number you wish your series...

The search is not case sensitive :confused: Have a look at the Double Click event of the List box.

That would certainly be an argument for letting NGO's do the job of distributing the money.

The code here should do what you are looking for.

Welcome to the forum. What you are looking for is a cascading Combo Box set.

You can either try and help people where they live, or wait for them to arrive on your doorstep as refugees looking for help.

Sorry the Form's On Current would need; Me.TextBox2 = 255 - NZ(Len(Me.TextBox1),0)

You could use the following in TextBox1 On Change event; Me.TextBox2 = 255 - NZ(Len(Me.TextBox1.Text),0) You would also need it in the form's On Current event

Your DB only has one table :eek: I think the first thing you are going to need to do is normalise your table structure, a tutorial may be helpful in this task. As it's stands I have no idea what the relationship between your three combos is or how you would filter them down :confused:

Welcome to the forum. Perhaps the sample here is doing the sort of thing you are looking for.

The field Last Name has no space in it :banghead: try; SELECT CustomerID, FirstName, LastName, Phone FROM [Customer Information] WHERE LastName LIKE 'x*'

Try; SELECT CustomerID, FirstName, LastName, Phone FROM [Customer Information] WHERE [Last Name] LIKE 'x*'

Welcome to the forum. Have you tried using the * wild-card character in place of the %

Perhaps one of the video tutorials here will help.

Welcome to the forum. I think you should find that this article explains how to do what you are after.

Sorry I'm a little confused about exactly what you are trying to do :confused: Could you step us through what it is you are trying to achieve.

Try; Between Nz([Forms]![F Searchall]![StartNo], 0) And Nz([Forms]![F Searchall]![EndNumber], 100000000)

Perhaps the sample here is doing the sort of thing you are after.

What you are looking for is a Cascading Combo Box set. The criteria you would use would be; Forms!YourFormName!YourComboName You would need to Requery the Cascaded Combo in the After Update event of the Master Combo and also in the Form's On Current event.

Perhaps the discussion in this thread is headed in the direction you want. You will need to read through the whole thread.