Hi Shiznaw

it sounds like what you want to do simaller to cascading combo boxes.

See if this document from microsoft will help you Basing one combo box on another I've used it for "combo to combo" and combo to list"...

Ok. What I've done to see the value of the cell is place an text box over the combo box. While this shows the index number, I want to show the actual text like in the combo box.

How do I get the Text box to look up the following:

SELECT stbl_Service_It em.SubService_I D, stbl_Service_It em.Sub_Service_ Details, stbl_Service_It em.Service_ID
FROM stbl_Service_It em
WHERE (((stbl_Service _Item.Service_I D)=Forms!main!S ervice!Service_ Item))...

Hi Everyone.

I've been having a little touble with a form I'm working on. (I'm a MS Access hobbiest). I've set up the cascading combo boxes, which is working, (I took the code from Microsoft) on a single item form.
However as the form I need is a of tabular type, every time I update cbo1 to a value, the non matching cbo1's cbo2 field blanks out. The data remains as but is hidden, and not what I need.

The data...