Show Values

[Eranka]

Name: Untitled.jpg  Views: 17  Size: 70.4 KB  ID: 37518" class="thumbnail" style="float:CONFIG" />

Hi Everyone, Please see above image.

I want show each row values from a table in these texboxes.

when i select Invigilator ID, Semester ID, Exam Type, the textboxes below should be filled with values (values from each separate row in table). how to do this part?

[Eranka]

Any suggestions guys

[davegri]

Let's start with some basics:
I'll assume your image is from a form. Are all of those fields (including the search comboboxes) fields within the recordsource (the table) for the form? Are the fields bound to the controls on the form?

[orange]

Eranka,

There aren't many details in your post; could you tell us more about the data (sources) and the form design?

[June7]

Review http://allenbrowne.com/ser-62.html

[Eranka]

Hey Guys

Combo Boxes are the search boxes, like i said when i select values from those combo boxes, i want the unbound textboxes to fill with values from table. Each row of those textboxes are equal to each rows in table fields.

[June7]

Suggestion is to bind the form to table and bind textboxes to fields. Apply filter criteria. The link provides example of that.

You show only 7 rows - what if more than 7 records meet the criteria?

[davegri]

Combo Boxes are the search boxes, like i said when i select values from those combo boxes, i want the unbound textboxes to fill with values from table. Each row of those textboxes are equal to each rows in table fields.

You're simply repeating your first post. Why won't you answer our questions?

[Eranka]

Hi guys

found a way to do it. I just added another subform, which shows the results when the values are selected in the combo boxes. thanks guys