Recent content by Lance55

Thanks Ansentry, your example is exactly the type of thing i'm trying to do however its a bit too complicated for me, so i'll stick with my order form for now even though making a new order for an existing customer will be a problem. Maybe if I use linked forms instead of trying to have it all...

Hi I have made an ordering system which appears to work fine however somewhere along the lines i've lost the unit price completely and it no longer appears on the sub form on the order form. I can't see why its not working. Any help would be much appreciated. Cheers Lance

Hi I have a database consisting of four tables which are tblCustomers, tblOrders, tblOrder Line and tblProducts. I need to make an order entry form much like the one in the Northwind sample database however all my attempts at making a form containing all of the fields needed to make an order...

Thank you for explaining I think I get everything apart from the ID part in the first paragraph of your post. I've tried to implement your search for my access database however when I perform a search the record is found but when I click it, it returns the error "Field ID is not in the current...

Agehoops could you explain how it works please? I don't understand it. Its definitely they type of thing i'm trying to do.

Hi I need to write a search function for my access database. I have an order form on which I have two text boxes labelled First Name and Surname I would like the user to be able to enter text into these boxes and using a command button be able initiate a search of the Customer Table for the...