Search results

Strange behaviour, not that you need to but if you create a second query to sum up your subtotal what value does it return. I do prefer coding stuff but doesn't fill you full of confidence if it doesn't work.

You need to build the query up like I suggested in the Query Builder or change the view to SQL and paste in that full statement.

If you change the textbox source to just subtotal on the sub form footer what does it show?

Does the field you are adding to the form contain a date value? Just click on that control and change the Format property to mmm/yyyy

Did you create the Query with the Query Builder? (I updated a previous post)

Its best practice to not have spaces in your table names, field names etc Try adding [ ] around those names. Is that in the SQL view or did you add all of that in the query builder in the criteria row? You would need to add the * as one column then add the client name as another column, untick...

What does your query look like and what is the name of your search textbox?

How are you getting the data with the combo? Are you typing a name and other text boxes on the form are populating? You could set you listbox to have a control source of a query that uses a search box as a parameter i.e. SELECT * FROM tblTABLENAME WHERE fieldName LIKE *...

You could also set the DEFAULT value of the control to Date(), Time() or Now() to pre fill the value.

Best way then would be to create an UPDATE Query with a Parameter value of the ID of the record you want to update, just use the FORMS!FormName!Field notation and use the DoCmd.Run in your button event.

What isn't working? How many records are you wanting to update? Private Sub btItemSave_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Dim txtItemNo As String Set db = CurrentDb ' Create a Query with just the records you wish to update ' Set rst =...

Create a query with all the records you wish to update, pass that in the openrecordset, Create a loop like something like Do While not rs.eof rs!field = value ..update rs.movenext Loop And then they'll update each one not just the first

You are only choosing the first record in the chosen table. You either need to use a query to find the particular record you wish to change or create a loop to go through a set