Search results

I have now added on the combo boxes on enter the coding to display this month and years so now its onto the query Between DateSerial(Year([Me].[cboYear]),Month([Me].[cboMonth]),1) And DateSerial(Year([Me].[cboYear]),Month([Me].[cboMonth])+1,0) is for the same form, would it be Between...

no imput mask, for some reason it has set a format to date, I have now removed it

there is no control source

This is when I select the month from the combo box. I get that error

Right is was Allow Edits on the form. I now get a error of "The value you entered is not vaild for this field" What format does the fields in the table need to be?

both say unbound

both combo boxes now provide the drop down data although neither let me select any yet

i just set the row source type to value list and it worked, think it was looking for a non existant table

yes, Private Sub Form_Load() DoCmd.Maximize Dim strYear As String Dim iYrItem As Integer For iYrItem = Year(Now) - 2 To Year(Now) + 2 strYear = strYear & CStr(iYrItem) & ";" Next strYear = Left(strYear, Len(strYear) - 1) Me.cboYear.RowSource = strYear End Sub

I put it on the forms on load field

I get an error about could not find the microsoft jet database engine

I would like it to show the month names to be more clear

access 97 sorry

back to the combo box I set rom source type to value list and use 1;2;3;4;5;6;7;8;9;10;11;12 and repeat for years 10;11;12 ect.

But as the forms source data is form the Data Query if the date is changed it would change the the forms data as long as the query is ran before the form is open

but once the query filters by the combo box I wouldnt need the button to run the filter it would be done as long as everytime the date is changed i rerun the query, is that right?

i am just going through and changing the date ones

I did have data but removed some earier. The main form is Main Menu and the query is Data Query and I am going to remove all the macros and replace with VB coding

its date, i am using 97, our work doesnt like to keep up with the times

does the monthname function work instead so I get March, April ect or wont it filter