I am creating a used car site. The site has a feature sale which is displayed on the main page. The feature sale is determined by a "feature" (Yes/No) in the "vehicles" table.

I am tring to create a form that opens the current feature vehicle (WHERE feature = True) as well as the vehicle that the user has just searched for using the car's VIN.

I need the current Feature "feature" (Yes/No) box to now = false and the new feature vehicle's feture feild to = True. This would then be saved in an update query.

Am I doing this right? Can anyone help?

Thanks,
Matt Cooper


Matt Cooper
Plan B Solutiosn