Search results

try setting the property !!modal!! on that smaller form to no but keep the pop-up yes then vise versa if no luck!

hi, thats what i did when i clicked on prev report, the report maximized on the screen and the form was behind it! everything works this end - just how you described. i have uploaded pictures to prove it. you must have a problem somewere else sorry

i hope this is what you are looking for? if its not i must be honest im stuck with what you would like to do! here we go

you havnt??

hi, could you post a sample copy of your database so i could have a look? mabey sort the problem

these settings are the same as on a form in the report properties

check my last post! should do the trick

right sorry about how long it is taking to sort such a seemingly simple problem! lets try a different aproach forget about hiding the form just make the report pop-up infront of it! on the report properties set popup to yes ,modal to no , auto resize to yes and auto center to yes if you would...

you are closing the form with the data on and then re opening it as hidden correct? do you have to enter the data in the form you wish to display in the report? if so the form wont re-open with the data you want to display! if so your code would have to be what rockape first said...

glad i could help :-)

ha ha sorry about the name!

just to clarify folks, Me.txtdate3 = DateAdd("d", 2, Me.startdate) Me.txtdate4 = DateAdd("d", 3, Me.startdate) Me.txtdate5 = DateAdd("d", 4, Me.startdate) ^^^^puts the dates in the boxes^^^^ and If Me.txtdate3 = Me.enddate11 Then 'do something End If ^^^^checks for the equal^^^^...

brainwornock, thank you so much for the hint - how could i be so stupid to forget format creates a string, obviously been looking at this problem too long! thank you for your time and help

sorry dont understand! i am quite an amature to access code! where i can do quite a few things im lost with this one

open the form in hidden view Dim stDocName As String stDocName = "your form name" DoCmd.OpenForm stDocName, acHidden

i am sorry to have wasted your time but i did say in my first post that this was an UNBOUND form and the entries in the txtboxes were generated by the code!

i have never used it before how would i use it in this context? thanks

can no one help me? im on my last brain cells here! lol i dont understand why i cant get access to recognise 1 date field as being the same as another date field? sounds like it should be simple to me! is it not?

sorry guus i dont understand what you mean! the entering of the date is fine. it populates the txtbox's fine and with correct formatting what i want is is the code to recognise that one of the txtboxes is the same as a date in a txtbox i specify e.g enddate thanks for your reply

hi, guys this is my first post on here! ive been using this forum for well over a year now and its been a god send! hope you can help me with this one, ive searched the forum and others like mad and just cannot find a solution. i have an unbound form which is populated by another form's...