Search results

I have a form that contains Customer Call Details (form A) and a seperate subform that contains customer address details. I needed a way for the staff to be able to search and list records by searching under the customers last name. I've achieved this using an Unbound text box on form A, that...

Thanks for the reply :) Yes I have a Transactions Table, at the moment this is storing the SalesRef, PartID, Quantity Sold, Date I was using the Transactions table to also Hold information of Inbound Stock to calculate the Stock on hand via a seperate query. There is a separate Parts table...

I have never done a stock \ sales database before, normaly just Customer Service or Booking ones. I'm still in the process of designing this new request and was wondering how you tackle historic data for sales items? At the moment I have a [parts] table that holds the PartID, decription and...

No worries, fixed it with this post

Anybody help with this annoyance. I've a continuous form that uses dlookup to grab a part description from a separate table. However on the records that yet to have a value selected I'm getting a #error in the dlookup field. The Control source is =DLookUp("partdescription","tbl_parts","partid...