Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a sub form in Access: enter image description here enter image description here

The CopyNo is a combobox that lets me select from the MovieCopies table. When I select one, I want the Title field to show the correct movie title associated to that copy's movie ID. I also want the format to show. When I select from DaysRented combobox, if I select 1 and the movie is New, I want it to display the price, if it is regular for 3 days display the correct price etc.

I'm just not sure how to give logic to the comboboxes.

If anyone could point me in the right direction of how to do this sort of thing in Access 2007 I'd really appreciate it.


share|improve this question
Did you end up finding a solution to this problem? Because without an answer, this question isn't helping anyone – Ivo Flipse Jul 15 '12 at 18:14
The data tab has a change event. When you select a movie from CopyNo it will fire allowing you to place code to update the other fields. – wbeard52 Jul 27 '13 at 16:08

by using either Before update or After Update events, you can fire the appropriate code to fill in the blanks

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.