Search results

no i just want the month and year, the database is like a monthly reporting tool

ok done what next

in what bit

I have messed about with the control source on P1list. MainMenu is the form with command button 8 opening for P1list

its almost 1am here now

still no joy, same error msg

so it match the textbox so the form displays it like that and then the form can be filtered by whats in the textbox, is it wrong

it isnt coming out as that now

run time error 3075 syntax error in date query expression '[dateofwork]'=#march10

i have mmmm, yy to give the same format as text box in the query

no not now

is it easier to email or upload it

but does it matter it come out 03.11 and not march 11

ah got you sorry guys I did say I am new to this all, so if I run a query to change all the date data to month and year it should work

does it help if i tell you guys the textbox is eg. march 10 and the field value 14/03/2010

DoCmd.OpenForm "P1list", acNormal, , "[DateOfWork]=" & Chr(34) & Forms!MainMenu.monthtext & Chr(34) sorry

Run-time eroor 2501 The openform action was canceled You used a mothod of the DCmd object to carry out an action in Visual Basic, but then clicked Cancel in a dialog box, For example, you used the Close mehtod to close a changed for, then clicked cancel............... Oi give me chance

i got an error

ok I have DoCmd.OpenForm "P1list", , Forms!MainMenu.monthtext but it doesnt filter the data

yes the monthtext is on form MainMenu how do I add it to oCmd.OpenForm "P1list" ,, P1list is the form I need to filter the data