I have got a table containing names and addresses, and I need to occasionally print a page of labels for individual people on the table. If you enter the person's full name on a form, it may select more than one record (in other words, there may be genuinely more than one person with that name). In order to select the correct record, I then ask for the date of birth (in short date format), then open the querydef in VBA, and alter the SQL property to include the date on the end. When a recordset is used to pick up the record, it sometimes gives the error 'No Current Record'. It does this if the month you enter is between January and September, i.e. one-digit, and it still does it even if you type in a leading zero. If you go to query design, it will have a date in the format dd/m/yy, where it has been automatically 'truncated' and gives no records - as soon as you put a leading zero in manually it will select the correct record. I have tried various things including: change the date format, put an input mask on the form control, various things with the Mid() function... Any ideas?