Need Assistance with Forms

[JDA2005]

So I tried finding my problem all morning but was left unsuccessful so I'm here seeking help from you fine people.

Essentially I'm trying create a form that has values within the form update other values. In this form, I'd like a Fee Schedule to be able to be selected, and that in part gives a value in the BPS (basis points) text box which will later act as a multiplier for a certain value.

I tried messing around with combo boxes but was left unsuccessful in the end. I also created a table that lined up all the fee schedules to the corresponding BPS. Heres what it looks like...






Thanks for the help.
John

Edit: Do I need to use a union query based on the table in order to populate this, I'm confident I need to do something with that and a combo box?

[RuralGuy]

You have not supplied enough information yet so that we can give a reasonable answer. A union query guarantees you will have a non-updateable recordset. Having controls update other controls on a form is rather simple. Why not start with one example you need solved and we could probably supply an answer if you give us enough details.

[JDA2005]

I appologize for my lack of clarification.

As you can see in that form, I want to be able select a fee on the large list to the right, and have that generate the corresponding BPS that goes with that fee.

I'm far enough along to know that I need to create a table or use some sort of query in order for this to be functionable within the form.

I guess instead of using a union query I am simply trying to have controls update other controls within a form.

let me know what needs to be clarified,

John

[RuralGuy]

You can put code in the AfterUpdate event of the FeeSchedule control that updates the BPS control if that is what you need.

[JDA2005]

Doesn't an afterupdate calculate a rate?

In my situation, I'm using a fee schedule, for instance.
Fee Schedule = BPS
1.1 0.0032
1.2 0.0020
1.3 0.0025

Therefore, I want the user to be able to select the fee schedule (by double clicking), have that populate the BPS, enter the given value and then the value be multiplied by the BPS.

I'm a newbie when it comes to this stuff so bare with me.

I really appreciate the help,

John

[RuralGuy]

An AfterUpdate event *only* does what you tell it to do. As for "DoubleClicking" a ComboBox, why would you want to do that. Normally you would press the DropDown arrow and select what you want from a ComboBox.