Form Issue

[Mnewton911]

This is a 2 Part Question - I am relatively new to the world of creating forms and have been tasked with the development of a new tracking tool.

I have the basics of the functionalities down however some more advanced functionalities are escaping me as i cannot find any remote reference to them in my access reference.

Here are the 2 things i am trying to complete on my form.

1) I have a master table of Rules which has the name of the rule and various fields that are related to the rules. I also have a table which i am using to track changes to various details to the rules. I have created a form which i would like to display the values displayed within the master table on the form which will then save the changes into the changes table. I have already created a combo box which displayes the name of the rule from the master table - howver i do not know how to get the other text boxes to display the stuff from the master table and have it save to the changes table.

2) For that same form, when you mouse over the field, i would like a label to pop up which gives a brief description of the rule. - How would i go about doing that?

Any help in doing this would be greatly appreciated! -

 

[boblarson]

For part one, let me just say that you should not be storing the "extra bits" that the text boxes would display. If they are something that is related to the ID that the combo box is saving (I hope you're saving the ID and not the description), then you can use a query to pull it all together when needed. But normalization rules state that you should not store duplicate data.

See here for a sample on how to DISPLAY the values while not saving them.

 

[Mnewton911]

bob,

Thanks for the VBA code update. I have one question when looking at the code since i am relatively new to programming in VBA. It appears to me as if you ar assigning the results from the query that you generated within the combo box - is the "me" referencing the query that is generated as well as the columns as they appear on the form.? -

The reason why we need the values saved from the output into another duplicate table is because we have to run history reports of changes that have been made to the rules.

For Example ( condensed)
Master Table Columns:

Rule
Multiplier
Deny Code
Support Code


When we then utilize the combo box which shows the rules referencing the master table - we want the other fields to be populated in the form so we could see what the current values are before we change them. - We make the changes within the form - it saves with an id # AND A DATE within the "changes table" and then we have a feature to update which i have built already. the problem was getting the values from the other table to populate.

Also is there a way to mouse over a text box and have a label pop up which i can write a description of something. ?