Datasheet List combined with cmd buttons - Any Ideas?

[Cwoolley]

I am putting together a search form that will query a list of debtors and determine whether they have account(s) or check(s). I would like to return something similar to a datasheet view combined with command buttons. Something like:

|---Datasheet Portion----|----Command Buttons----|
| Lastname | Firstname | | cmdChecks |
| Lastname | Firstname | cmdAccts | |
| Lastname | Firstname | cmdAccts | |
| Lastname | Firstname | cmdAccts | |
| Lastname | Firstname | cmdAccts | cmdChecks |
...
...
...
And so on, for an indeterminate number of records...

The cmd buttons would be visible or not depending on whether the debtor had one, the other, or both. Clicking on a cmd button would take the user to a new form that lists the checks/accts of that debtor.

I had planned on using a datasheet view of my query and then using something like the "On Retreat" event of a report to set the cmd buttons visible/not. I see that the 'Detail' portion of my form doesn't have an "On Retreat" event and now I'm finding that the datasheet view won't allow me to put command buttons on it anyway.

Anyone got any good ideas on how to tackle this? I can think of a way to loop through all of the debtors found by the query and create a new row of text boxes and buttons with each new record, but I don't know how to position the controls on the form and I'd also have to determine how big the form was, etc. That way seems overly complicated. I guess I can do it if noone has any brighter ideas...

Thanks!

 

[dalenz]

Hi Cwoolley,

Have you thought of using a continuous form and then you can use the on click or on dblclick event to go to the detail form.

 

[Cwoolley]

Dalenz:

Thanks for the reply. Yes, I've thought of using a continuous form, but I don't know how to differentiate between accts or checks. I want the form to show if there are accts or checks, or both, and then give the user a choice of which one to pull up. I'm not sure how I would do it with a continuous form. Any ideas would be welcome.

This is what I envision the form looking like...

http://www.aitsinc.com/form.jpg

Thanks again!