Data Access Page and RecordSource

[Krukloaf]

Hello, I am creating a DAP with a combobox and about 7 text boxes all linked to the same table. I want to be able to select a value from the combobox and have the textboxes be automatically populated with the corresponding info. I figured this could be done through a select query in the recordsource, but I have no idea how to do this. Any help would be greatly appreciated!

 

[FancyPrairie]

I'm not sure what exactly you're trying to do. I'm assuming that when the user selects an item from the combobox, you need to goto the record that conains that info. If so, there are a couple of ways to do it:

1. Filter the data
MSODSC.CurrentSection.DataPage.Filter = "YourFilterString"
MSODSC.CurrentSection.DataPage.IsFilterOn = True

2. Find the Record
MSODSC.CurrentSection.DataPage.Recordset.Find ...

This should give you a start.

 

[FancyPrairie]

I'm not sure what exactly you're trying to do. I'm assuming that when the user selects an item from the combobox, you need to goto the record that conains that info. If so, there are a couple of ways to do it:

1. Filter the data
MSODSC.CurrentSection.DataPage.Filter = "YourFilterString"
MSODSC.CurrentSection.DataPage.IsFilterOn = True

2. Find the Record
MSODSC.CurrentSection.DataPage.Recordset.Find ...

3. Can't remember
There's another way of doing this that I think is better than the other 2. I believe it has something to do with groups. Can't seem to find where I saw it. If I find it I'll let you know.

This should give you a start.

 

[Krukloaf]

wow, that's exactly what I'm trying to do. Both methods worked just fine. Thanks for the help.