Query help

[Damo10]

Hi,

I have a form that uses the date, name and department from another form as the default values, I have created a query that looks at these and gives the max value of how many enteries have been made for that person for the specidied date.

Can i run this query and have the number from the "max of Enteries" field as the deafult value for a textbox?

 

[xenou]

Strange that if your control is a combobox you can have a query as its source. I was just looking a few days ago at comboboxes - wouldn't it be great if you could display them without a scroll bar (so you have a combobox that looks like a textbox and can have a datasource?). A listbox of the right size might even do ... Hmm! Anyone ever try this?

As far as you're question goes, you can populate the texbox from behind your form with a query result:

Dim rs As DAO.Recordset
set rs = CurrentDB.OpenRecordset("Select Max(Field1) As MaxOfField1 From Table1")
If Not rs.EOF Then
    TextBox1.Value = rs.Fields(0).Value
End If
Set rs = Nothing

This could be in an open event for the form, or triggered by some other appropriate event.