Retrieving per row data for Cmbobx on Datasheet

[ItsDouglas]

I'm using Access 2003. I have a datasheet located on a tab control. The datasheet is unbound as I populate it via ROWSOURCE after the user has made a selection from a combobox on the tab control. That all works fine. My question is that I have data located in a CHILD table that I want to populate a Combobox control with for each row. Yet when I setup the ROWSOURCE for the Combobox with a SELECT statement, the retrieved records get populated into every row in that combobox on the datasheet. (Im not sure I am making a lot of sense here). What I need to be able to do is look at a value in each row of the datasheet, use that value to retrieve records from another table and populate the combobox on that row with just those child records. But those records will be different, obviously, for each row on the datasheet. Yet Access populates every row's combobox with the same set of child records regardless of weather or not they are children of the value I am passing through the SELECT statement.I should note here that I already have a subdatasheet attached to this datasheet (and you can only have one subdatasheet per form), so I dont think that is an option for me.

Wow, doesnt make a lot of sense I guess. Please let me know what additional info you might need and I will post it. Thank you in avance!!!!

Doug

 

[TheAceMan1]

ow are ya ItsDouglas . . . . .

In the [blue]Current Event[/blue] of the subform datasheet, [purple]requery[/purple] the combobox . . . .

See Ya! . . . . . .

 

[ItsDouglas]

Aceman1

Thank you. That solved it. And saved my bu** for a weekend demo I have to give.

I think I better click on the 'Click here to donate' link for Tek-Tips as I couldn't begin to estimate how many hours/$$ the answers on this site has saved me.

Thanks again
Doug