Search results for query: *

Good call, Ronald - star for you! I needed to NOT run the procedure if the record was a new record, because I referenced the AutoNumber - and at that point, it doesn't exist. Here's the code I ended up using: If Me.NewRecord Then GoTo Update_Vendor_Combination_End_Click End If

My day was saved without [me] also! [thumbsup2]

Excellent post - helped me out tremendously. Raphael

I am in need of the "autonumber by prefix" code - could someone be so kind as to send it to me? I am trying create "line numbers" for each record in a subform that is related to a record in the main form. Thank you for your help! Raphael Bernard rbernard@stfrancishealth.org

Buttons.zip is riddled with erorrs - I can't even click the first button without getting errors.

chassle - thank you very much! That works, and it seems like the ONLY way it's going to work. Oh, and I have to set the format on the text boxes to LONG DATE or mm/dd/yyyy or else I get strange results. Thanks again! Raphael Bernard

I know somebody can help me - I'm trying to pull data off an AS400 database with Access 97 query. When I put the dates into the criteria line (and it gets automatically formatted with the #'s) like this: Between #5/1/01# AND #5/1/02# - it works just fine, but if I ask it to prompt me like...