Choose a value from a combo box based on a text box

Slim Shamble

Slim Shamble

Joined
Jun 3, 2016
Messages
1
Reaction score
0
Hi

I am new to Ms access. I have a form which is use to input student data for assessment report. i have a text box and a combo box namely total and status respectively. the status has its own text in it as Pass & fail. I want my combo box value to change to pass if value in total is > 45 and fail if value in total is < 45.

I hope is understood. Kind respond will be appreciated.

Seal D Deal.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi Select List Box in Access 0
Validation rule for Combo Box 0
sum combo box based on other combo box 2
Populate a text box based on a combo box 1
Access Control on subform / combo box requesting parameter 0
auto populate text box based on combo box value 1
Combo box values and continuous forms 1
Combo box output excel 2007 2

Top