Hello. I've searched the threads and Google and have not come up with a solution to this; let me explain.
1) I have a continuous form
2) Each record in the continuous form has a cost code associated with it. This cost code is in this format ##.###.###
3) The numbers in the cost code have text descriptions which are identified in another table. I'm doing this so that my database is normalized.
4) I want my users to be able to edit the cost code on my continuous form.
5) I DON'T want my users to be able to edit the text descriptions of the cost code. Ie, the text descriptions are meant to be READ-ONLY.
Solution Idea #1
A sub form would work wonderfully but, alas, as you are all aware you cannot have subforms inside the detail section of continuous forms.
Solution Idea #2
I tried to invoke a query onto the control source of my form. This worked... however, it disabled the ability to add a new record and I need this ability.
And that's where I'm at... all I want to be able to do is READ data from another table while I'm editing the current table inside of a continuous form.
I'd sure appreciate some help with this. Thanks in advance.
1) I have a continuous form
2) Each record in the continuous form has a cost code associated with it. This cost code is in this format ##.###.###
3) The numbers in the cost code have text descriptions which are identified in another table. I'm doing this so that my database is normalized.
4) I want my users to be able to edit the cost code on my continuous form.
5) I DON'T want my users to be able to edit the text descriptions of the cost code. Ie, the text descriptions are meant to be READ-ONLY.
Solution Idea #1
A sub form would work wonderfully but, alas, as you are all aware you cannot have subforms inside the detail section of continuous forms.
Solution Idea #2
I tried to invoke a query onto the control source of my form. This worked... however, it disabled the ability to add a new record and I need this ability.
And that's where I'm at... all I want to be able to do is READ data from another table while I'm editing the current table inside of a continuous form.
I'd sure appreciate some help with this. Thanks in advance.
