Subform Link Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi groupies:

My main form displays Projects, Compartments and Blocks. I have cascading
combo boxes to select a Compartment and then a corresponding Block within
that compartment. My blocks have a numerical block id and a block name. I
need the block name to show up in the combo.

I need my subform to link to the BlockId number but that is not visible in
the combo.

How can I make the correct BlockID show up on my main form so that the sub
can link to it. Or how can I write the linking statement so that it links to
the ID column (0) in the combo from the master
 
Set the RowSource of the combo to include both fields

Select BlockId , BolckName From TableName

Set this properties of the combo:
1. Set the column width of the combo to display the Id
0 cm; 5 cm

2. Column count - 2

3. BoundColumn - 1

Now the combo should display the name but hold the id as the number, so you
can use the combo as the parent field of the main form
 
Sorry for the delay in responding.........Internet issues.

I actually had things set up the way you explained and I couldn't for the
life of me figure out why it wasn't working.

So many times it comes down to relationships........I didn't have the
BlockID field in the query of the subform..........

Thanks for stearing me in the right direction.
 
Back
Top