Search results

Do you have it set to unique VALUE, or unique RECORD? Needs to be VALUE esp since you have an AutoNumber field "ID"

Oh sorry, didn't see that. Ok I am going back to the date possibly being entered as date AND time, not just date. How are the dates being entered in the first place? Make sure your date field on the table is not formatted to include time. And make sure your entry method does not include...

can you post your SQL statment? I have a feeling I know what the problem is, I just need to verify.

is your date field really a date/time field? Sometimes its formatted to only show you the date, but the REAL entry has the time with it!!! I would check on that Also you can use the conversion tools to force it to a date type format in a consitent mannor to do your original distinct idea.

Ok From Design view click on the combo box go to its properties click the Data tab click the "..." to the right of the Row Source field that will bring up the query builder I am assuming you have some sort of query already set up at the top middle of the screen you will see a "∑" character...

I don't think I fully understand the problem you are having, but you should try using the groupBy command instead of distinct. I tend to have better success with that over the DISTINCT command

Try this: on the AfterUpdate() event of the style textbox, put in your event procedure Forms!MainOrderForm!CuttingNumForm.Form!Style1.requery

I am not sure I have completely understood, however. It sounds like you are trying to treat a report like a form. Primarily speaking, reports are for viewing and printing only. Each time you type in the values using my code, then close and open the report, the report starts from scratch and...

No problem. Glad it helped. I might have made another adjustment to the code after I posted, its been to long and I can't remember. But if it has any issues, let me know and I will go back and peek at the project I used it in and let you know.

I know this is an old post, but I believe I found the solution for anyone still needing one. You don't have to populate unbound textboxes on a report via a form or table. All you have to do is: Option Explicit Dim SaveTyping As String Private Sub BOM1_KeyUp(KeyCode As Integer, Shift As...