Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Difficulty displaying data in controls within subform

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I'm doing some coding in Access 2000
I have a main form with a single subform inside it.
When the subform opens the various unbound combo and textboxes on it are empty.
In code I open a dao recordset and set the combo boxes and textboxes to the relevant string and integer values in the recordset fields. The value property and text property of the controls change, however on screen the controls are still empty.
The controls are visible, enabled and not locked.
Does anyone have any idea what my problem might be.?
 

Working with subforms can get real challenging!

I am assuming that your Master and Child field links are established in the subform control and the subform is the source object for the subform control and that all other data related to the record is being displayed properly on the subform except the unbound controls. Are you wanting to edit the data in a field on the subform using a combo box?

Try replicating what you want to do by creating a querydef in the QBE grid that displays the fields for the subform and then using the query as the record source for the subform. See if that displays the data and then you can create a dropdown list for the combobox with your recordset as the row source and the corresponding field from your query as the control source of the combobox.

Mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top