Recent content by LimitedAccess

Yep, works a treat. Thanks :)

Thank you guys much appreciated, I will go away and concatenate :D I'll let you know how I get on, such a learning curve.

Hi Guys, more help required for what must be a common requirement. I've had a search but sure it must have been covered before. As part of my company database I create purchase orders as a report. The address displayed on the purchase order is taken from that saved in the SupllierDetails table...

Telecom's answer is a good one (although no error handling in the sub ;o) ) Are you able to initiate an Event Procedure Jammy, does that make sense or is it like DoubleDutch? Sorry to ask, but you may need to read up on Event Procedures first?

On the left hand side of the Visual Basic editor is a list of forms and reports, double click the form that you are interested in and a window should appear with all of your subs code.

Are you able to cut and paste the code you have for the form, Including the procedure for the radio buttons? Without the whole picture it's hard to quote the exact coding. From the Visual Basic Editor

Can't you just add an Event Procedure for the radio button so that On Click that makes the required text boxes, ListBoxes etc locked/not enabled? As in.... Forms!Frmwhateveritscalled!TxtBoxwhatever.Enabled=False

Thanks, but the problem with removing the filter is that the form then displays the first record in the table rather than remain displaying the selected contract from the 1st form, although it does then allow you to navigate through all of the records. But with some 5000 records it would take an...

Hi Chaps First post so hope I'm not thrown to the floor and kicked for this question :D Youknow how it is when you know just enough to get yourself through, but stumble on silly little things for hours :( This relates to a database of company contracts past and present and my question relates...