Hi,
I have what seems to be a very simple problem, but I just cant work out how to fix it.
Within a database I have bodged together with limited know-how and alot of luck I have 2 combo boxes on a particular form. One lists all parts of an engine that could fail and the other lists all the areas that all these parts are fitted. What I want is when the part that has failed is chosen, the area it is fitted in is automatically inputted, so that the user cannot choose the wrong area.
The data is stored thus:
the failed part is stored in a table called Part, which has 2 columns - the part, and the area it is fitted.
The data entered is then stored in a table called Engine Data which, among others, has 2 columns, failed part and area.
When the part is chosen from the combo box how can I get the area to be automatically filled in?
I have looked through many other posts on cascading combos etc and all they do is confuse me.
Please understand that I have no VB experience and limited Macro and Code experience. In fact I only know enough of Access to do what I have already done...please help!!!!
I have what seems to be a very simple problem, but I just cant work out how to fix it.
Within a database I have bodged together with limited know-how and alot of luck I have 2 combo boxes on a particular form. One lists all parts of an engine that could fail and the other lists all the areas that all these parts are fitted. What I want is when the part that has failed is chosen, the area it is fitted in is automatically inputted, so that the user cannot choose the wrong area.
The data is stored thus:
the failed part is stored in a table called Part, which has 2 columns - the part, and the area it is fitted.
The data entered is then stored in a table called Engine Data which, among others, has 2 columns, failed part and area.
When the part is chosen from the combo box how can I get the area to be automatically filled in?
I have looked through many other posts on cascading combos etc and all they do is confuse me.
Please understand that I have no VB experience and limited Macro and Code experience. In fact I only know enough of Access to do what I have already done...please help!!!!
