I hope that someone can help

[mr moe]

I have a database the keeps tracks of printers by serial number. There is a form for doing this, the form has a serial number field, and a status field "example move, add, remove" , effective date and a location field. Here is what I want to do, lets say that the current location for serial#ABC is in location C and then the user opens the form and tries to move serial #ABC to locaiton C, how can i display a message saying that Serial#ABC is already at location C, maybe I can do this by a DLookup or by a record set, but the only thing that i'm struggling with is how do I make it look at the latest record by the effective date. Thanks.

 

[rainman89]

DMAX will give you the last record based on date

 

[mr moe]

I want to do this in a code because I want to run the code in the after update statment for the serial num field. so should I do it thru a select statment and then if the locatoin.field.inform is = to dmax in table then dislpay message???

 

[KeithG]

Can you post an example db? I will can show you in the example.

 

[mr moe]

sample copy

ok attached is a simple sample copy, open the form, what I want to do is create a new change order and in the form, I want to choose for example serial number ABC which is already in the table"it has three records" and then I want to choose "Add" Status and I want to put a date for effective date and I want to put "Dearborn" as a location,
in this case
i should i get an error message saying that the printer is already in "Dearborn" I want to do this after I look at the Dmax date for serial # ABC and if it's in an ADD Status. Thanks.

 

[mr moe]

sample copy

here is a sample copy.

 

[mr moe]

Guys Help Please It's Holidays

Ok Should I try to write dmax in sql and compare the results with the form input data? Please Please Please Assist, I know it's not as simple as you think.