Recent content by pantscat

Thanks Mr. Scouser! So... can any of you other clever bods out there help? In a nutshell... all I want to do is: Apply a filter to a textbox on a report which gets its value with the Dlookup command. I'm not even sure if it is possible... :confused: Cheers :D

Thanks for the suggestion - but I'm afraid that it wont do what I want it to do... Edit: I should explain why... sorry was rushed off to drink coffee! There is one recordset per page - and the fields come from two or three different related tables - so the grow-shrink thingy wont do the trick...

Filter Report to eliminate blanks... using VBA! (help!) Hello all, I'm currently playing around with a school report system and I have a problem whereby not every pupil studies every subject - and so I want to stop the "blank" reports from printing. I thought that perhaps I could it using the...

Yes... that pretty much makes sense to me. Thank you ever so much for your help - is very much appreciated! Ant

dcx - I LOVE YOU! :D (in manly back-slapping kind of way...) It works! Thank you so much... you have saved me many hours of frustration and beating my head against a rather pointy monitor. Ant btw - I don't understand what the & " '" did... and I'd be very curious to find out.

I have tried changing the name of the text box to txt_subject - but I still have the same problem - it brings up an Enter Parameter Value box and I've just noticed that it is asking for the value for one of the records in the subject field. I'm not sure if that made perfect sense - the...

Yes.... Would that cause some confusion? having a control named identically to a field on the report?

Checked and double-checked this already - they both match as both the form and the report have the same source table. I'm a wee bit stumped. Thanks, Ant :confused:

Thanks Rich, That very nearly works - but now when I click my button an "Enter Parameter Value" box appears... grateful for any ideas, ta, Ant

Apologies if this is a common post but I have searched and tried to find an answer to this but I cannot. Oh.. and hi! :) I am trying to add a button to one of my forms so that "onclick" it will open a report and filter it based upon the content of the form. I have tried to use the following...

Hello everyone! I'm somewhat of an Access newbie... used it a bit in the past, but never to do anything what I would describe as clever. I'm trying to use conditional formatting to change a bound text box on a report to a different BackColor. E.g. when the bound field is blank leave the...