Update a specific field in a new record in subform

[Guest]

I have a subform, based on a query that fleshes out the detail of the child
table. The idea is that the child table will just store an issue code, but
the issue itself is tied to another lookup table.

The problem I have is when I select the issue type, I am restricted to
selecting issues from that type...then I wantr to put the actual issue code
(which is a column selected in a combo box tied to one of the "extra" columns
in the query) in the field tied to the actual child table.

So, in psuedo code, I want to do something like this:

CurrentRecord(IssueID) = cboIssueCode.Column(2)

Where "CurrentRecord" is the technique eluding me, and "IssueID" is the
hidden column in my subform datasheet...

I hope I've described this well enough for a better Access developer to give
me a hint...TIA.

 

[Steve Schapel]

Ed,

Do you have an IssueID field in the table that the subform is based on?
If so, can't the combobox be bound to this field? I'm not really sure
here, because I haven't quite grasped the relationship between the
IssueID and the IssueCode and the Issue... maybe some examples would help?