Recent content by Lighty_11

Cheers Guus, you've helped me loads....... I did found a solution myself.... It turns out that because my ScannedOrderNumber field wasn't indexed, it would not allow the related record to be edited. Once I changed it to "Yes (No Duplicates)" it has now allowed me to edit each and every record...

Right, i've managed to get the table to populate a form with the additional fields relating to the order numbers i've scanned.....Perfect. However......I need to be able to update these fields to add order notes, change the post details but I can't - all the records seem to be locked. I...

Thanks Guus, I have briefly looked at this with some success and although this will give me a solution, in reality it would not be practical. We are looking at handling maybe 1000 orders per month, where some orders coming from sub-sites will use a different format order number. With the...

Hi All, I am designing a DB containing website orders. At the moment if I want to update records to show orders as posted, I have the order_reference field prompt me for a perameter value and I update one order number at a time. What I aim to do is create a query that searches for multiple...

Thanks for your suggestions.....I've moved forward slightly and managed to prevent the option groups from duplicating down the form. What happens now is that the checkboxes themselves aren't working properly and it's also setting the value my control fields to 0 as soon as one is ticked. I have...

Simple now you say it, can't believe I completeley overlooked that. Cheers, Lighty

Hello All, I have created a continuous form for submitting multiple postal details to a table. The problem I am having is when a checkbox in the option groups is ticked, it also ticks the same option for all entries on the form. I need these to operate independently but I also need to keep the...