I need to update a record on a specific date. I am creating a renewal process for a club and there are several member types. So once they fill out the renewal, the chosen membership type needs to replace the current one, but not until the current membership term has finished.

if your running SQL server, you can use a stored procedure or command to run code everyday and check the current date against the one on the db with the membership details.

should be able to do this with acces too, but with a stored query (doesnt have no stored procedure)

then something along the lines of

function
check date
if date = old date
renew member


Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com