Text Box Problem

[jenvandiver]

Hi - thanks in advance for the help!

I have a tblType, which includes TypeID and TypeTitle. I also have a tblSTRAP that includes a field for the TypeID for each particular STRAP.

I have a frmTest where I have included cascading combo boxes for the user to choose the following:

cbo1: TypeID and TypeTitle (TypeID is saved in tblSTRAP)
cbo2: MOSID and MOSTitle (MOSID saved in tblSTRAP), etc.

This is working well as far as saving the ID data to tblSTRAP, however, on a separate form I need to show both the ID and Title data. This is where I'm having a problem because I don't know how to pull the Title data up (TypeTitle, MOSTitle) since this information is not included in tblSTRAP. I would like to avoid subforms.

Is there a way to add the title information automatically into tblSTRAP based on the corresponding ID the user chooses from the cbos?

I appreciate any guidance anyone can give me!!!


tblType tblSTRAP

 

[jenvandiver]

Wow! That took care of it.

Thanks for your help!

 

[jenvandiver]

That's why I love this website. Every problem I've ever struggled with for hours has been solved in no time by posting it here. It's the best resource I have. Thanks to people like you!