Textbox = combobox gives #Name error?

[Johnny]

I have two subtables, tblHoursAvail and tblSignup.

The HoursAvail table has a column called HoursAvail1 which is populated by a combox box based on a lookup table.

Switching to my form now I can easily put a unbound text box in the subform based on tblHoursAvail and put its control source as =[HoursAvail1].[column](1) and it works great. User selects the value its repeated in the text box.

But I need the selected value in HoursAvail subform to display in a text box on the OTHER subform. When I put a unbound text box in the subform based on tblSignup and use the exact same expression it just gives me a #Name? error?

What am I doing wrong?

 

[SmallTime]

Not sure if I've got the right in of the stick here

Your first subform RecordSource is tblHoursAvail which has a field HoursAvail1, so you can point to it without problems.

Your OTHER subform RecordSource is tblSignup (No HoursAvail1)

Can you now see where the problem might be?

You don't need or want to have repeated data in both tables so you'll need to related the two tables with a common field. Then you can use various methods but I think the best and easiest way would be to to base the forms on a query built with data from both tables.

Regards
SmallTime